Forum Discussion
Solved
Sorting a string based on the measure
Hi, I have a measure called Balance Due which is concat of another measure called Total Balance Converted and the currency column. Now this Balance Due is a string but I want to be able to sort thi...
Hi, sprakash99
As a workaround, you can consider hiding these two columns directly in the matrix after the field 'Balance Due' is sorted based on field 'Total Balance Converted'.
(Turn off the 'word wrap' option in the 'Format' pane of this matrix -> Reduce the column width to 0)
Best Regards,
Community Support Team _ Eason
Hi, sprakash99
As a workaround, you can consider hiding these two columns directly in the matrix after the field 'Balance Due' is sorted based on field 'Total Balance Converted'.
(Turn off the 'word wrap' option in the 'Format' pane of this matrix -> Reduce the column width to 0)
Best Regards,
Community Support Team _ Eason