Percentage in Pivot Table

[upaliwije]

I have created Pivot Table as follows

DESCRIPTION	ACTUAL    2014	ACT_RATIO	ACTUAL    2013	ACT_RATIO
SALES	7,332,885	100	967,954	100
LABOUR	339,527	7	222,262	7
MATERIAL	831,338	14	338,969	14
COMMISSION	890,125	12	75,000	12
GROSS_PROFIT	5,271,896	68	331,722	68
STAFF_EXP	853,494	11	40,000	11
ADMIN_EXP	857,451	11	80,000	11
SELLING_EXP	509,639	7	100,000	7
TOTAL_EXPENSES	2,220,584	29	220,000	29
OTH_INCOME	40,000	1	40,000	1
NET_PROFIT	3,091,312	39	151,722	39

I have calculated Actual Ratio bases on the Sales Value of Each Year for 2014 and 2013.But The calculation returns the same ratios for  both years . Kindly have look at my QV document and help me to correct the expression to suit my requirement

[jyothish8807]

Hi Upali,

Can you share your expression you are using? Personal edition issue.

Regards

KC

[upaliwije]

The below is my expression

Sum(ACTUAL)/$(=$(=vActual))*100

vActual=sum({$<DESCRIPTION={'SALES'}>}ACTUAL) is my variable

[jyothish8807]

Hi Upali,

Rename in the field in your budget table:

load

year,

month,

sales as bud_sales,

labour as bud_labour,

.

.

.

from <>

In exp:

Sum(sales)/sum(bud_sales)

Use your condition which ever you are using.

Hope it will work.

Regards

KC

[upaliwije]

Thanks

Budget Sales has nothing to with the Actual sales. What I want to calculate the Ratio of Labour Material etc against Sales

[jyothish8807]

Hi Upali:

try this:

exp:

sum([ACTUAL    2014])/sum(TOTAL([ACTUAL    2014]))

In number tab:

Select integer

show in percentage,

PFA

Regards

KC

[upaliwije]

Thanks for your help

But this not what I am Expecting

SALES	7,332,885	100	967,954	100
LABOUR	339,527	5	222,262	23
MATERIAL	831,338	11	338,969	35

My requirement is as follows

5%=(339527/7332885)*100

23%=(222262/964954)*100

[upaliwije]

Pls  help me a an Answer

[jyothish8807]

Hi Upali,

for Material do you want like this?

(831,338/7,332,885)*100

Regards

KC

[upaliwije]

yes that is correct