Forum Discussion
Solved
Sorting by Month in Matrix Table
Hi, I am trying to sorting out Matrix table by month. As you can see I have in alphabet order; but I would like to see in Calendar order. I am using three columsn in Matrix , Year, ...
Sorry, I may be misunderstanding what you have done, but...
The date table should be sorted by the date column.
To sort the Month Name column, you need to select it and then use the "Sort column by..." and choose the month number as the sorting column.
They are two seperate "sorting" operationsIf you have a measure, you can create a new measure using SWITCH to create the order measure and use that as as the sorting criteria
