Forum Discussion
Sorting Matrix by multiple levels - summary, then week level
My goal is to sort a matrix by the 2022 Sales, then press the + sign and sort by the week level (1,2,3,4, etc.) Do you have any tips to recreate this?
Posting a solution with descending weeks:
one method is to:
-add the 2022 running total as a column
-sort this column descending
-turn off text wrap for column headers and values
-hide the column (Click and drag the column header border to the left to shrink the column)