In Matrix table, sort by a rank column

[Anonymous]

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

[TheoC]

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! 🙂