Pivot table - Dynamically calculating range columns

[projectile]

Hi
I'm trying to get a dynamic calculation added to columns E and F, that will output the actual Variant + percentage Variant between columns B and C .

However I'm struggling with getpivotdata() formula, as it appears to get confused with the fact i'm using a "Column range".

I have manually added a static formula to columns E and F to demo what I'm trying to achieve .

I need this to be dynamic, so I can use this workbook as a pivot table template, so that users can paste their data extract in to the "extract" sheet and simply refresh the pivot table for their stats.

Hope this makes sense.

[José Augusto]

Try this in E5 and copy down

Please Login or Register  to view this content.

and this in F5

Please Login or Register  to view this content.

[projectile]

Thanks very much Jose, that worked just great!

[José Augusto]

You are welcome.
D'ont forget to mark this thread as SOLVED.