Sort a matrix table by multiple fields

[rgsalido]

I have to sort a matrix by different fields, and some of them are not in the visual object itself. Is it possible?

Thanks

[JustSayJoe]

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.

[pratyashasamal · Accepted solution]

Hi @rgsalido ,

There is no direct way to sort multi columns in matrix. As a workaround, you may refer the following link.

Matrix multiple Sort columns 
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C