how to get total sum in the stacked bar chart ?

[#1]

I have a grouped x-axis drill down dimension.(geo,area,..)

• when I click on the stacked legend
• it actually is not displaying the 100% of the all the fields in area level drill down
• i wrote a set analysis expression
• how to achieve this in grouped drill down
• when I click on 46%

• the NM/GW , PLAT, PS/CAN ARE SEPERATELY 100%
• BUT REQUIREMENT IS TO GET THE SUM OF ALL NM/GW+PLAT+PS/CAN=100%
• I ATTACHED A SIMILAR FILE
• THANKS IN ADVANCE