PA Report - Pivot table month issue

[Sneha Anil2]

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

[Sneha Anil2]

Hi Atul,

I need to create it on Pivot table to show counts and I'm using Custom field in Incident table.

Thanks,

Sneha 

[Dr Atul G- LNG]

Then it is not possible, mate. In Pivot it will only show as a digit.