Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
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