Columns Outside Pivot Table But Linked to PT
I have created a pivot table from (OLAP); however, there are additional calculations that I must do outside the query inside Excel using adjacent columns; hence, I use GETPIVOTDATA to retrieve information from inside the pivot table and then work my formula magic.

My challenge: When I refresh the table data using a different month, the total rows in the pivot table will change depending on newly inserted data or deleted data within the pivot table, which causes my totals outside the pivot table not to align properly now.

How can I make sure columns outside the pivot table remain aligned with the columns of those inside the pivot table so my formula reference will correspond to the pivot table?

Thanks much