Forum Discussion
Jeanxyz
Power Participant
Power Participantsort a matrix table by a hidden measure
I have a matrix table where the open amount column are actually a text string (because I need to add dynamic currency prefix). as a result, I can't sort open amount correctly because this column is...
Yea, this is really sucky. I've been looking for a solution for this myself. My usual go to is either:
1. Add the sorting column and make it width 0 (requires wrap to be turned off for column headers)
2. Build it into a diffren column with a rank. Eg.
1. PPD5
2. CR356
I hope someone else has a better solution though
NickolajJessen
Solution Sage
Solution SageYea, this is really sucky. I've been looking for a solution for this myself. My usual go to is either:
1. Add the sorting column and make it width 0 (requires wrap to be turned off for column headers)
2. Build it into a diffren column with a rank. Eg.
1. PPD5
2. CR356
I hope someone else has a better solution though
- Jeanxyz
Thanks, I used the first approach. 2nd approach only works with a column field, not a measure, I guess.
