Any help on set analysis with Avg and Total

[#1]

I have a Dimension with Target % which has calculated Averages.While Using in Measure with set Analysis as Avg(Target %)giving Averages and need to have a Total of sum.

Set analysis i used    =Avg([Target %])

Items	Target %
A	-10.0%
C	5.0%
D	75.0%
UnScored	5.0%
Total	20.0%

Above Target % Measure is giving individual values as Average but Total is also taking Avg but expected is Total need 28.21%

[kkkumar82]

can u be clear on ur requirement, 28.21% is no where matching ur data given.

[matthewjbryant]

I agree with kiran ch; we need more information to understand how you are arriving at 28.21%.

Having said that, on the Expressions tab there is a section for Total Mode. Play around with Expression Total and the drop down menu.