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

Malaya
Giga Expert

Please refer to this link:

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

jl11
Tera Contributor

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.

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.

Malaya
Giga Expert

Yes.

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

Thanks,

Malaya