Report Sorting Question

Hello,

I am not able to sort a count column numerically from largest to smallest. In this project, I am grouping departments to measure how many departments submit the most requests. I am able to group the departments by name, and summarize the departments by count. However, the report will only sort the columns by the department name alphabetically. I want the count column to be sorted from largest to smallest. I have tried sorting by the count column but it does not change no matter how I set the sort settings.

I have already created a helper column in the original sheet, and made sure it is showing as numerical value to not get confused as text, but no luck.

Does anyone know what might help?

Find more posts tagged with

Reports

report column

sort

group by

Auto sort rows

Accepted answers

All comments

Naeem Ejaz

Use count if formula to count the requests.

Paul Newcome

You will need to use a separate sheet with formulas containing cross sheet references to get your counts. Then you would create your report referencing this metrics sheet so that you can apply your sorting.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.