Is it possible to sort one column via values of another hidden (metadata) column?
Why is this desired?
- When Sorting dollar values, it is desirable and more consistent if we sort by numerical values instead of string/formatted dollar values.
- When Sorting non-zero padded values with prefix/suffixes, sorting would only work through an index of sorts.