GetPivotData

[Steve Powell]

Hello - in using Excel 2003 I could reference cells in my GetPivotData
formula such as =GETPIVOTDATA('AF Data1'!$J$10,$A52&" "&$C52&" "&$D52&"
"&$E52&" "&AB$1)/$F$2

Now in Excel 2007 the formula is =GETPIVOTDATA(E52&"",'AF
Data1'!1:1048576,"[Restate Segment]","[Restate
Segment].[All].[FED].[].[].[DEFENSE].[AIR FORCE/ARMY TACTICAL].[AIR
FORCE]","[Fiscal Qtr]","[Fiscal Qtr].[All].[2006Q01]","[Product
Group]","[Product Group].[All].[Desktops]","[As Sold Rev Band]","[As Sold Rev
Band].[As Sold Rev Band1].[As_Sold_Rev_BandXl_Grp_1]")

Excel 2007 does not seem to let me change this string ,"[Restate
Segment]","[Restate Segment].[All].[FED].[].[].[DEFENSE].[AIR FORCE/ARMY
TACTICAL].[AIR FORCE]" to a cell that references Air Force

 

[ryguy7272]

I do this, but a little different, like referencing a cell, which has the
same name as the Field in your Pivot Table:

Just today, I set up the function below:
=GETPIVOTDATA(E$2&"-"&$D12,Sheet1!$A$4,$A$2,$A11,$B$2,$B11)

E2 and D12 are cells that have values which Fields in my PT. I have found
this to be better, because as you fill down and fill right, the references
are all updated dynamically.


Regards,
Ryan---