Platform Analytics - Pivot table

[Stimson]

I need to create a pivot table with month name and year (sorted in ascending order) and configuration items as rows aggregate by count, 

The problem is can I have a datetime column start time which should be represented as mmm yy format (Jan 24 etc...)

Do we have any workaround without creating a new field in the table?

Current:

Start	01-02-2023 5.30	01-03-2023 5.30
Configuration Item
A	100	100
B	100	99.87

Required:

Start	Jan 23	Feb 23
Configuration Item
A	100	100
B	100	99.87

[Abbas_5 · Accepted solution]

Hello @Stimson,

Please refer to the below link:
https://www.servicenow.com/community/developer-forum/how-to-change-the-date-in-a-pivot-table-to-mont...

Mark my correct and helpful, if it is helpful and please hit the thumbs-up button to mark it as the correct solution.
Thanks & Regards,
Abbas Shaik