GetPivotData Result of Pivot Table that Refreshes

[A_mutant]

Hello,

Would anyone know what to get the Grand Total of a Pivot Table to export out to another sheet when the table refreshes. Because the Pivot Table refreshes the location of Grand Totals keeps changing, breaking my formula.

I have been told GetPivotData function would work for this but I have been unable to get it to work. It breaks as well when the location of Grand Total changes.

Thanks

 

[A_mutant]

I think I found it. I was using the GETPIVOTDATA wrong. If I use the $column$row in the formula it seems to be working.