report

FranckM
Tera Expert

Hi dear SN Community,

do you know if there is possible to sort the order counts in a pivot report?

See below. i created this report and want to sort the count descending to get the highhest count at the top. 

i have an add sort "icon" displaying the filter but it doesn't works for the count. Do you know if possible? and how?

FranckM_1-1738152164209.png

 

 

4 REPLIES 4

Dr Atul G- LNG
Tera Patron

Yes @FranckM 

 

AGLearnNGrow_0-1738154997890.png

 

 

You will sort option, in conditon builder.

****************************************************************************************
Regards
Dr Atul G. - Learn N Grow Together ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
******************************************************************************************

Yes i have the sort option as well but it doesnt work. Did you try it in your pivot?

i want to sort the count descending.

Hi @FranckM 

 

You are right, it is not working. Might be bug. You can log a Now support case.

****************************************************************************************
Regards
Dr Atul G. - Learn N Grow Together ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
******************************************************************************************

FranckM
Tera Expert

yes, i can see the sort option as well but cant use it to sort the count. See my pivot, i want to sort the count descending.