Sorting a Group By Field in Report

baraka
Tera Contributor

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

7 REPLIES 7

Hello Baraka,

 

See my above screenshot where you can do "Sort z to a"

Ex: Assignment group --> Z to a

Mads Jensen
Tera Contributor

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!

flawed_81
Tera Guru

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