how can I get 100% in each bar for each dimension in bar chart?

[#1]

in this image1

• the x-axis is a group drill down
• where when I DRILL DOWN to next level, its actually still calculating the level-1 %
• but how can achieve the similar 100% calculation for all the levels in the drilldown

the images will show the respected scenario

and how can I get group in the expression to get this drilldown in the expression

[swuehl]

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])

[#3]

will it calculate exactly as the drill down is clicked ,

like :

if i click on area

will it calculate according to that level

[#4]

[#5]

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

[#6]

hi,

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?

[#7]