Hello got a barchart with two dimensions : Fiscal Year, and Region in this barchart I'm displaying the total by the above dimesions plus the values so the Region dimension is calculated dimension as follows: pick(Total,Region, 'Total') Total is a dimension I created in the script from an inline table with two values 1, and 2 so far so good
Now I want to sort the result not as acending / descending but custom as follows: Match ( Only({1} [BUSINESS_UNIT_DESC]), 'Canada','Latin America','United States' ,'BU1','BU2','BU3','BU4','BU5','AM', 'Central Europe','France Benelux','MEA','Nordics Russia','Southern Europe + Morocco','UKI','Total' )
I'm getting the following result:
but I want the Total to be placed on the far-right so how can I update the formula of sorting to accoplish this