Cross Tab Sort by Month Name and Year?
Summary
Is it possible to sort Cross Tab Columns correctly by Month Name and Year?Content
I run into this problem all the time where I am not allowed to sort Month/Year columns if I have the Month and Years written out by name and the Year is listed prior to the Month.
For example, I would like to sort columns correctly with names like December 2020, January 2021, February 2021, etc.
If you display the columns by Month Name and Year, they just get sorted as strings and look like my attached example.
I know that I can get it to sort correctly if I format the column as YYYY/MM, but that looks so ugly and I would like to format by the traditional Month Name and Year.
Tagged:
1