Sorting a Group By Field in Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2019 10:13 PM
Hi,
When creating a List type report, you will have the option to Group by a field. Once chosen, your data will be grouped by that field. The list report will show the data grouped by the field chosen, however the order of the grouped by field cannot be changed even when using the Add Sort Field option.
E.g. I'm creating a list report to show the incidents that I have closed. I've grouped those incidents by their parent incident and I want the report to list the parent incident number in a descending order ( currently it's in an ascending order). Please advice if that can be done.
Thanks
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2019 03:28 AM
Hello Baraka,
See my above screenshot where you can do "Sort z to a"
Ex: Assignment group --> Z to a
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2022 11:51 AM - edited 11-06-2023 12:40 PM
List reports:
When I sort by Group: I can only sort by name alphabetically.
I want: Sorting group by number of incidents.
ServiceNow - please, come on!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2023 05:35 AM
I believe there is a known problem about this, and it will not be addressed by ServiceNow - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1251189