Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
(Sum(PREMIUM)/Before(Sum({<YEAR>}PREMIUM)) - 1) * Avg(1)
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)
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)
Thnaks
not working