PA Report - Pivot table month issue

Sneha Anil2
Tera Contributor

2 hours ago

Hi All!

I want to display a month field in a Pivot Table visualization to show incident categories by month.
Currently, I have added a calculated/functional field that returns the month in the format YYYY-MM (for example, 2025-12). However, I need the month to be displayed in the month name format (for example, Jan, Feb, etc.).

I tried formatting the field to show the month name, but this causes an ordering issue in the report, as the months are sorted alphabetically instead of chronologically.

Could you please suggest the best way to display month names while maintaining the correct month order in the Pivot Table?

 

Thanks,

Sneha

0 Helpfuls
  • 30 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron

2 hours ago

Hi @Sneha Anil2 

 

Any screenshot to understand the problem you are facing.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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