report

FranckM
Tera Contributor

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
Tera Patron

Yes @FranckM 

 

AGLearnNGrow_0-1738154997890.png

 

 

You will sort option, in conditon builder.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

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.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

FranckM
Tera Contributor

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.