Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

report

FranckM
Tera Contributor

‎01-29-2025 04:03 AM

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

 

 

0 Helpfuls
  • 435 Views
4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-29-2025 04:50 AM

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]

****************************************************************************************************************
0 Helpfuls

FranckM
Tera Contributor
In response to Dr Atul G- LNG

‎01-29-2025 06:05 AM

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.

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to FranckM

‎01-29-2025 09:12 AM

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]

****************************************************************************************************************
0 Helpfuls

FranckM
Tera Contributor

‎01-29-2025 06:07 AM

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.

0 Helpfuls