Sorting Matrix by multiple levels - summary, then week level

[zoellerkl]

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?

[zoellerkl]

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)