question Sorting a Pivot Table by the Total Column in Platform Analytics forum

Sorting a Pivot Table by the Total Column

jl11 — Wed, 24 Feb 2021 19:04:26 GMT

Is it possible to sort a pivot table report based on the total column?

I have a Pivot Table showing Incidents by Source Type and Category. I would like to sort the report by the Total Column so we can see the highest to lowest hitters.

I have seen many questions asking this but no solution.

Re: Sorting a Pivot Table by the Total Column

Malaya — Thu, 25 Feb 2021 00:39:37 GMT

Please refer to this link:

https://community.servicenow.com/community?id=community_question&sys_id=e6d1f59adb526780f21f5583ca961933

Re: Sorting a Pivot Table by the Total Column

jl11 — Thu, 25 Feb 2021 20:37:11 GMT

Thank you for the reference. This was helpful. Hopefully in the future there will be a way to sort on the Total Count column on the Pivot Table if possible.

Re: Sorting a Pivot Table by the Total Column

Malaya — Thu, 25 Feb 2021 21:13:02 GMT

Yes.

Could you please mark is as correct response so the thread can be consider closed.

Thanks,

Malaya

Re: Sorting a Pivot Table by the Total Column

CHSlehmanREL123 — Tue, 20 Feb 2024 16:11:15 GMT

I agree. Having the inherent capability to sort the column values within the pivot is the most user friendly and ideal way to remain productive.

Re: Sorting a Pivot Table by the Total Column

CHSlehmanREL123 — Tue, 20 Feb 2024 16:17:53 GMT

This is not a correct response. You offered a workaround of how to view data in a different format. Bar Charts with associated data tables below is NOT the same as presenting data in a pivot table. When users need to report data in a pivot table, it is useful to be able to sort the columnar data. You offered an alternative source of looking at data that negated the ability to view the data in a Pivot with the usefulness of having sort order capability. If the ability is NOT in ServiceNow, then it would be good if they added this functionality in subsequent releases.

Re: Sorting a Pivot Table by the Total Column

LaurentChicoine — Tue, 23 Apr 2024 21:04:27 GMT

For your information in the latest release of ServiceNow not sure exactly at which release it became possible, this is the default for pivot reports inside the Platform Analytics Experience.