Ratio issue

[upaliwije]

I have following Pivot table in my documnet

SITUATION 1
DESCRIPTION	ACTUAL	ACT_RATIO
INCOME	2,665,244,812	100
EXPENSES	256,525,524	10
SITUATION 2
LOCATION	DEPT 1		DEPT 2		DEPT 3
DESCRIPTION	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO
INCOME	1,278,071,014	48	866,770,079	33	520,403,719	20
EXPENSES	108,549,183	4	72,843,841	3	75,132,500	3

Under situation 1  when I divide the expenses from income i get the correct ratio of 10%

but under situation 2 when I do the same after adding Dept dimension I get a incorrect ratio

Ratio result I am expecting should as give below

SITUATION 2
LOCATION	DEPT 1		DEPT 2		DEPT 3
DESCRIPTION	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO
INCONME	1,278,071,014	100	866,770,079	100	520,403,719	100
EXPENSES	108,549,183	8	72,843,841	8	75,132,500	14

My expression is =fabs((Sum(ACTUAL)/$(=$(=vActual))*100))

pls help me get correct results from Oivot table

[MK_QSL]

Use

SUM(ACTUAL)/SUM(TOTAL <LOCATION> ACTUAL)

[upaliwije]

Tks

How can I modify my expression (=fabs((Sum(ACTUAL)/$(=$(=vActual))*100)))with location

[MK_QSL]

What is the expression for vActual?

[upaliwije]

I have created a variable for income as follows

vActual=sum({$<DESCRIPTION={'INCOME'}>}ACTUAL)

[MK_QSL]

change it to

SUM(TOTAL <LOCATION> {<DESCRIPTION = {'INCOME'}>}ACTUAL)

[upaliwije]

I have done it still the result is like this

LOCATION	DEPT 1		DEPT 2		DEPT 3
DESCRIPTION	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO	ACTUAL	ACT_RATIO
INCOME	1,278,071,014	48	866,770,079	33	520,403,719	20
EXPENSES	108,549,183	4	72,843,841	3	75,132,500	3

[MK_QSL]

Provide sample app

[upaliwije]

I m attaching a sampal file  pls

[MK_QSL]

Can you provide the expected result in excel file?

This file having different figure than original question