Sorting a Pivot Table by the Total Column

jl11
Tera Contributor

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.

 

1 ACCEPTED SOLUTION

Malaya
Giga Expert

Please refer to this link:

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

View solution in original post

6 REPLIES 6

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.

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.

LaurentChicoine_0-1713906181598.png