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

[Annica Smith]

Hello, 

I would love to have this functionality available. We want to be able to sort by pivot table column, and the count column. 

Thanks,

Annica

[Frans Brus - No]

Nowadays this can be done.

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_PivotTa...
But the sort field is only available in Reporting New UI. (i rather use the Classic UI)
After adding the sort field you can switch back to Classic UI and you can still see the Sort by field