Sorting data based on sum of values in 100% stacked bar chart

[Bansal_Kumar]

Hi Experts,

I have a chart where I have calculated 100% stacked bar chart based on Items and Supplier and in the measure 

SUM(Amount)/SUM(TOTAL <ITEM> Amount). but the problem is it is not sorted based on the sum(amount).

I want the values to be displayed in DSC order.

Please help.

[Usama]

Hi,

Go under the Sorting section (below Data section) then uncheck auto sorting and make the sorting in DSC order.


Thanks,
Usama

[Bansal_Kumar]

I Did that, Its not working.

[Kushal_Chawda]

@Bansal_Kumar  You need to perform sort by expression for your dimension "Item". Remove  sort option for other dimension. Check the below