I want to use the getpivotdata function to get data based on a cell reference
in excel 2007. My pivot table is from an analysis cube.
The getpivotdata function that is auto generated from clicking on the data I
want is
=GETPIVOTDATA("[Measures].[Order Quantity]",$B$5,"[Order Date Dim].[Year
Number]","[Order Date Dim].[Year Number].&[2010]","[Order Date Dim].[Week
Number Of Year]","[Order Date Dim].[Week Number Of
Year].&[17]","[Product].[SKU]","[Product].[SKU].&[2]")

I want to change the SKU that is retrieved from [2] (which appears to be a
reference to the 2nd record for SKU) to a cell reference. This way I could
take this formula and use it to retreive the same data for whatever SKU is in
the referenced cell. I hope my question makes sense?