in this image1
the images will show the respected scenario
and how can I get group in the expression to get this drilldown in the expression
Try just adding all the fields of your drill down group to the field list of the TOTAL qualifier.
Assuming Geo, Area, Region as fields in your drill down group, something like
=Count( [Quadrant_Pos]) / Count(TOTAL<Geo, Area, Region> [Quadrant_Pos])
will it calculate exactly as the drill down is clicked ,
if i click on area
will it calculate according to that level
when I am clicking on the 46% in NA i am actually ending up with next level dimension but the sum of the next level is not equal to 100%
how to achieve that?
when I click on 46%, this is how it is ending up,
but as per the requirement, I want that 46% as the sum of all the 3 (NM/GW, PLAT, PS/CAN)
Is there any way to change the expression
Retrieving data ...