How can I sort the data in a pivot table report by Count?

[YYeo]

Hi,

I have a simple Pivot Table report that shows each KB article and the # of View Counts for each of them. The pivot table is sorted alphabetically by article title, is there any way to have it sort by the # of view count instead, with highest view count first?

Regards,

Yourui

[RatneshTSN · Accepted solution]

In Pivot table, seems sort by view count is not working/applicable.

However, similar view count can represented in report-type[BAR] per article or topic & can be sorted by view count.

[CHSlehmanREL123]

If we wanted to view the information in bar chart form with accompanying data table below then we would create that type report. This reply is NOT however, an appropriate solution to the need to get a sort order capability within the columns on a Pivot report in ServiceNow.

[YYeo]

Hi Ratnesh,

Thanks for the quick response! That's too bad that it is not sortable for pivot tables. However, your suggestion worked. I have the data table displayed so that is the 'true' pivot table that the users will look at, and I tried to minimize the bar chart so it is not taking up too much space. 

[RatneshTSN]

Glad to know, it helped you.