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:
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?