I'm trying to calculate a compound average growth rate or CAGR in an Excel 2007 pivot table.
I am familiar with the CAGR formula:
((End Value / Start Value)^(1/N)) -1, where N is the number of periods.
My problem is that I have three pivot table fields: Items, Values and Years. What I want to do is something likes this: ((
Value[Year2012] / Value[Year2002]) ^(1/10)) -1
Is what I'm trying to do possible the way I have created my pivot table. Thanks for you input.