Forum Discussion
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, Quarter and Month.
Thanks
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
8 Replies
I take it you are using a Date Table, correct?If so, you need to sort the month name column by a month number column- if there isn't one, you need to create it- (select the date table in table view, select the month name column and use the "Sort column by" in the ribbon to select month number.
Hi,
Thank you for quick response.
Yes I have already done everything whatever you have mentioend. But still sorting is not working for MATRIX Table.
I have Month Number column in Date Table so sorted Date Table based on Month Number.
Thanks
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" operations
