I am trying to get the proper sorting for the stacked bars with the drill down group dimension based on the sales either descending or ascending.
Sorting works properly with the dimension, however when I tried to add the Drill Down group dimension it's not working as expected.
Solved! Go to Solution.
Have you tried giving a sort order for each of your dimension within the Group?
Or you can override the sort by dimension (by checking the box at the bottom of the Sort tab for the chart) and select sort by y-value.
Thanks for the reply!
The problem is with the Region sorting order on the stacked bar not the category/sub category drill down dimension.
For Technology category sorting of the Region stacked bar should be East,West, Central and South
In Expression Sort of Region
if(Region = 'East',
if(Region = 'West',
if(Region = 'Central',
if(Region = 'South',