Forum Discussion
Sort columns in a matrix by month - year
Hi all!
I would like to compare the values of a month between different years in a matrix visual, so I want to sort the columns of the matrix by the month - year hierarchy
In this case I want December to appear before January because in December I am comparing with year 2015.
How could sort by month-year??
Thanks so much.
Best regards
pgarcia,
What does your original table look like? If you have sample data as follows, when you create the Matrix, December should appear before January by default.
If you encounter issues by sorting, consider to add a conditional column as shown in the following screenshot. Then sort the Month column by the new column.
Regards,
Lydia
1 Reply
pgarcia,
What does your original table look like? If you have sample data as follows, when you create the Matrix, December should appear before January by default.
If you encounter issues by sorting, consider to add a conditional column as shown in the following screenshot. Then sort the Month column by the new column.
Regards,
Lydia