GETPIVOTDATA formula references

[diggerdan1974]

I have a large pivot table and I'm trying to build some reference calcs from it in a seperate table. I can't build the calcs in the actual pivot table because it's an OLAP DB source (or so I was told by someone in my IT dept).

I'm using Excel 2007 and the help posted in reply to my original question re: inserting calculated columns to a pivot table was for the prior version. Maybe there's a way to do this directly in the pivot table.

The table is revenue results by month for different categories of revenue. I want a percentage variance. I was planning on using the GETPIVOTTABLE formula to build atable and manually calc the % var.

I'd like to be able to make the highlighted text a variable reference so I can change the account ref, account description ref, and the month ref in teh resulting table. Any thoughts?

GETPIVOTDATA("[Measures].[Amount - GL Trans]",$A$4,"[Accounts].[Acct Segment 2]","[Accounts].[Acct Segment 2].&[76200]","[Accounts].[Acct Segment Description 2]","[Accounts].[Acct Segment Description 2].&[Computer & equipment expensed]","[Master Date].[Month]","[Master Date].[Month].[All Date].[February]")