You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cross Tab Sort by Month Name and Year?

edited Apr 21, 2021 9:24PM in Reporting & Analytics for B2C Service 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!