I understand how to use the custom calculations in the field settings in
pivot tables to derive a simple annual growth rate, using % Difference From,
(previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates
(CAGRs) in a pivot table for each year in the series from the initial base
year?

I have tried doing a calculated field, but then the column total reflects a
sum of the CAGRs and not the CAGR for the total.

I think using the "FV" or "FVSCHEDULE" function might be what you are looking
for.

"dunes" wrote:

I understand how to use the custom calculations in the field settings in
pivot tables to derive a simple annual growth rate, using % Difference From,
(previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates
(CAGRs) in a pivot table for each year in the series from the initial base
year?

I have tried doing a calculated field, but then the column total reflects a
sum of the CAGRs and not the CAGR for the total.

Thanks, but I don't think that's quite it, if I'm understanding the Excel
help feature.

I don't have a single growth rate for future years. I'm trying to calculate
the compound annual growth rate based on levels given for the years in
question.

"mmcap" wrote:

I think using the "FV" or "FVSCHEDULE" function might be what you are looking
for.

"dunes" wrote:

I understand how to use the custom calculations in the field settings in
pivot tables to derive a simple annual growth rate, using % Difference From,
(previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates
(CAGRs) in a pivot table for each year in the series from the initial base
year?

I have tried doing a calculated field, but then the column total reflects a
sum of the CAGRs and not the CAGR for the total.