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.
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.
Retrieving data ...