Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Help sorting my Pivot Table chronologically while displaying only months

Topic Labels: Extensions
748 0
cancel
Showing results for 
Search instead for 
Did you mean: 
DZZ
4 - Data Explorer
4 - Data Explorer

Hello, I’m trying to order by Pivot Table columns by months throughout multiple years while displaying just the month and year for example “January 2020, March 2021, April 2023”. The problem is that the only way it’ll sort properly is if I append the year and month to the front of it like “2020-01”, “2021-02”, “2023-04”. It makes it much less nice to read:

Screen Shot 2021-03-10 at 11.49.38 AM

The part highlighted in red is necessary for the sorting to work properly. The part highlighted in green is ideally the only part I would like to show. Is this at all possible currently?

0 Replies 0