Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
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.
Thanks,
Venu
Hi,
some similar solution using rank as calculated dimension:
hope this helps
regards
Marco
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.
Sunny,
Thanks for the reply!
The problem is with the Region sorting order on the stacked bar not the category/sub category drill down dimension.
Example:
For Technology category sorting of the Region stacked bar should be East,West, Central and South
Venu
Hi Venu,
With some messing about it can be done. See attached qvw.
Thanks
Kumar KVP
Kumar,
Thanks for your efforts!
It is so unfortunate we have to really mess up to get this done.
Thanks,
Venu
In Expression Sort of Region
add
if(Region = 'East',
Dual('East',1),
if(Region = 'West',
Dual('West',2),
if(Region = 'Central',
Dual('Central',3),
if(Region = 'South',
Dual('South',4)
)
)
)
)
Hi,
some similar solution using rank as calculated dimension:
hope this helps
regards
Marco