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,

PFA

[upaliwije]

Hi Friends

Pls help me with a answer to my query

[jyothish8807]

Is the above attached is not working?

Regards

KC

[upaliwije]

It is working. But I have to create variable for each year. I have more than two years I want create one variable and change it as and when user select year