How to find growth % ?

[#1]

Hey,

     I have a pivot table with month-year as Row and the retention % as data. I need to find out the growth between the current yr's month against last years.

This is how the table looks.

Duration	Retention %	Growth%
APR 2009	20%
MAY 2009	40%
APR 2010	40%	100%
MAY 2010	50%	25%
JUN 2010	60%	100%

[its_anandrjs]

Hi,

You need to code some thing like this for Growth%

If(Year(Duration)= Yearstart(Today()) , Growth%)

For Growth% calculation it should work better

Hope this helps you.

Regards

Anand