Forum Discussion
Solved
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 ca...
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
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