Forum Discussion
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 using a measure in text format, which means the sorting is done alphebatically: $10, $1000, $900...., I need to sort this column by it's real value, something like like $10, $900,$1000.
I have created a open amount measure in value format (without currency prefix), but as I don't want to show this measure in matrix table, I can't not sort table by this hidden measure. Is there a way to sort the open amount column by it's real value?
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
2 Replies
NickolajJessenSolution Sage
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- Jeanxyz
Thanks, I used the first approach. 2nd approach only works with a column field, not a measure, I guess.
