Handling percentage when drilling down

[#1]

Hello,

Plz find attached I have an issue with calculating percentage while drilling down and drilling up.

[MK_QSL]

Change Expression as

Sum(Actual)/SUM(TOTAL Actual)

[#3]

Hello Manish,

See result i got which is very wrong

Where do i go from here?

[MK_QSL]

I don't think anything wrong in your chart...

Total is also 100%..

let me know what you think is wrong !

if you make the straight table for the same dimension and expressions, you will get below

Month	Actual	Target
	100%	100%
Apr	11%	8%
Aug	9%	8%
Dec	6%	8%
Feb	6%	8%
Jan	16%	8%
Jul	6%	8%
Jun	15%	8%
Mar	4%	8%
May	17%	8%
Nov	4%	8%
Oct	2%	8%
Sep	4%	8%

[#5]

See this. I doubt the formula. Because 2013 Target should b greater than Actual

[MK_QSL]

It is...

but as you have year as dimension and both year 2012 and 2013 are having same target, it is divided by 2 so they are showing as 50%- 50% as ratio.

[#7]

i want to use IF statement to calculate; if Dimension = to Year it should divide by 100 and when Dimension equal month does normal. i need assistance in implementing this..

[MK_QSL]

Elaborate little more please.. I am unable to catch your requirements.

[#9]

this is what i want

IF (dimension = Year)

     sum(Actual)/12

else

     (dimension = Month)

     sum(Actual)

This is what i want to achieve. because i already have created a drill-down field

[MK_QSL]

=IF($(=GetCurrentField(mYear))='Year',SUM(Actual)/12,SUM(Actual))