Forum Discussion

rgsalido's avatar
rgsalido
Advocate II
3 years ago
Solved

Sort a matrix table by multiple fields

I have to sort a matrix by different fields, and some of them are not in the visual object itself. Is it possible? Thanks
General Comment
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    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

JustSayJoe's avatar
JustSayJoe
Advocate IV
1 year ago

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.