Growth Calculation

[upaliwije]

Hi Friends

I want to calculate growth % in my pivot table. My Pivot Table looks like below

Here the Month and Year are Dimensions. My expression for calculation is sum(PREMIUM). I want to calculate yearly growth and output report should look like as shown below. Pls help me to to write an expression for growth % calculation

[sunny_talwar · Accepted solution]

Try this

(Sum(PREMIUM)/Before(Sum({<YEAR>}PREMIUM)) - 1) * Avg(1)

[upaliwije]

Thanks  Sunny

It works. I would like know  what does this part works and why it is necessary ? I can  not understand it * Avg(1)

[sunny_talwar]

Just to make sure that you still see a percentage when you make selection in Year field I had to ignore selection in year field.... once I do that, I might see all the years and to get rid of the non selected years, I multiply it with Avg(1)

[upaliwije]

Thnaks

[Dolly123]

not working