sort a matrix table by a hidden measure

[Jeanxyz]

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?

[NickolajJessen · Accepted solution]

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.