Growth Column

[upaliwije]

I have following pivot bale in my QV doc.

CLASS	2012	2013	2014
FIRE	6,781,118	7,271,519	7,339,058
HEALTH	6,747,988	8,178,199	8,486,264
MARINE	2,311,695	2,158,937	2,313,657
MISC	7,570,117	8,883,654	8,602,588
MOTOR	38,387,055	40,223,102	43,109,010

My espression for above is sum(PREMIUM)

I want to add a cloumn show growth over the years. Then the table should look like shown below

CLASS	2012	2013	%	2014	%
FIRE	6,781,118	7,271,519	7%	7,339,058	1%
HEALTH	6,747,988	8,178,199	21%	8,486,264	4%
MARINE	2,311,695	2,158,937	-7%	2,313,657	7%
MISC	7,570,117	8,883,654	17%	8,602,588	-3%
MOTOR	38,387,055	40,223,102	5%	43,109,010	7%

Kindly help me to write the expression for the above growth calculation.

[prma7799]

Can you please share formula for growth over the years

[upaliwije]

(7271519-6781118)/6781118*100

[prma7799]

PFA..

[upaliwije]

Thanks

I can do do it the way you suggessted. But when there are more year I have write expression for each column. Isn't there ant other way to do it please ?

[prma7799]

You can take dimension Class with Year (2 dimension) and  YTD LYTD  and Grwth  as expression and move dimension Year on above expression