I have a grouped x-axis drill down dimension.(geo,area,..)
so you want to stack NM/GW , PLAT, PS/CAN in one single bar ? to what level do you want to stack things together ?
i dont want them to stack them to single bar
i want them seperate but
when I click on 46%, i want to the division of 46% in 100% in NM/GW,PLAT,PS/CAN
you can store total of NM/GW+PLAT+PS/CAN in variable say vtot and while display contribution use this variable in expression.
you would need to base your aggregations on whatever is selected, and keep going down and since your drilldown has several levels it that makes it a tad more complex, I will try to look into some of my stuff to see if I have something that will work
Retrieving data ...