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.

Modification in reports type Pivot Table

DevYadav
Tera Contributor

Hi Community, Good Day!

I’ve created a report with the type set to Pivot Table, and I want to rearrange the columns.
I know that for choice fields, the column order can be controlled by adjusting the order of choices. But how can I do this for a simple string field?
For example, the Short Description field is used in the columns, and I want to rearrange the order of these columns. I am setting the value of row as priority field
How can I achieve this?


1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @DevYadav 

Adding a short description in a pivot table is not a good idea, as it can spoil the look and feel of the pivot table. Are you looking for sorting or something else? As far as I know, sorting doesn’t work in pivots. Do you have a screenshot of what you’re looking for?

*************************************************************************************************************
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]

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