Forum Discussion
Solved
Sorting the matrix by multiple values
Good day Is it possible to sort the matrix by 3 values at the same time like in Excel i.e. im my example I want Centres with all the highest % at the top. I must also mention that all the 3 value...
Step 1: In your Matrix, add a field to the row hierarchy (which you will later remove).
Step 2: Change the Matrix to a Table visual.
Step 3: Sort all the columns you wish to sort, and in the order you wish them to be sorted.
Step 4: Delete the field you previously added in Step 1 from the table.
Step 5: Change the Table back to a Matrix visual.
Step 6: Ensure the right fields are back in the Row hierarchy.
This will maintain your multiple sorted fields within your matrix, even when you expand your row hierarchies.