Array Formula in Pivot Table

[andrewc]

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!

[dilipandey]

Hi andrewc,


try entering formula normally (without pressing ctrl shift enter OR without putting { } sign)
In case still stuck, upload the workbook. thanks.


Regards,
DILIPandey
<click on below * if this helps>