Celle reference to a Dynamic Pivot

Hi,

I have a dynamic pivot which refresh with the change in the underlying data. I am storing the total values in the Pivot referencedanother worksheet for reporting. However when the pivot refreshes the last row changes and hence the reference cell is not working

Any suggestion to pick the last value of the dynamic pivot?

Thanks

You may use GETPIVOTDATA formula. Only reference necessary is top left cell of pivot table which will not move.