Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Go under the Sorting section (below Data section) then uncheck auto sorting and make the sorting in DSC order.
Thanks,
Usama
I Did that, Its not working.
@Bansal_Kumar You need to perform sort by expression for your dimension "Item". Remove sort option for other dimension. Check the below