1 Reply Latest reply: Oct 19, 2017 11:26 AM by Anand Chouhan RSS

    Custom Sorting - Amounts

    Kash Jani

      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.