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.