Hi,

I have created a pivot table (PT) with classification names in column A, monetary values in column B and growth rates in column C.

By default the PT sums the values in column C but I would like to replace the sum with a compounding array formula:

{=(product(1+c2:c1000/100)-1)*100}

Can someone please tell me how to do this.

Thanks!