Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

In Matrix table, sort by a rank column

I created a Rank column in a Matrix table that I would like to sort by.  The issue is I need to retain the groups set up in the PC column shown below.  Each PC Group should be sorted by the Rank numbers within that group,  Can this be done?

 

Thx

 

1 Reply

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Anonymous 

     

    I know this has probably been resolved, however, depending on the total disctinct number of "PC" categories, you could allocate each a numeric value starting at 1, concatenating the Rank to create a decimal value with two decimal places (i.e. 1.01... 1.99), and then use that column to sort?

     

    All the best and no doubt you've already figured this one out! 🙂