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.

`RATE`

formula is a superior method to calculate CAGR. In your example,`=RATE(2010-2002,,-10,50)`

works out the cagr for an inrcrease from 10 to 50 over eight years – brettdj Jan 15 '13 at 0:58