Columns Outside Pivot Table But Linked to PT

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

Insert calculated field can be used to give u error free formula

VKS,

Not sure what you meant by your answer (Please clarify). To elaborate as an eg. At time (0), the Pivot Table (PT) has 200 rows and my added excel columns have formulas referncing the specific 200 rows. If next month the PT expands to 205 rows (including deletions and additions), my added excel column referencing the 200 rows from last month will be off. I am trying to find a way that I can match up my outside PT formula column to match the PT as it changes dynamically each month.

Thanks FDibbins- I used your method vs Getpivot data and it worked even though my thoughts were along the lines of updating portions of the getpivotdata cell separately based on portions of its formula in each cell.
Two follow up questions:
1)As the range changes depending on PT results, do I use a dynamic named range on the outside PT calculation range or will the dynamic named range refer to the PT itself as it contracts and expands each month?
2) How can I copy filtered data to another sheet not as copy\past\value because I need the values to be formula driven as its source may change as my filtered data may be updated

Thanks in advance for your help