Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
We have a chart with a dimension and an expression with amounts. The amount is split in to millions and actual values i.e. if the value > 1 million, the values will be shown in million and if it is less than 1 million it will show the actual value i.e. 839,192.
Example
Country Amount
ABC 120 million
BCE 2 million
DEF 12,999
EFG 890,281
FGT 38 million
The problem we are facing is to set default and interactive sort. Is there we can have a custom sort so all above custom values are included in the sorting as below.
Country Amount
ABC 120 million
FGT 38 million
BCE 2 million
EFG 890,281
DEF 12,999
Currently the sort is done by numbers and it ignores the million representation.
Thanks for your help.
I believe Amount is your metric expression if so use this expression in your sort in the sort properties >> write this expression and do select there ascending
Ex:-
=Sum(Sales) but in accending order.