can you use a variable or cell reference in a getpivotdata formul.

[Guest]

for example;

GETPIVOTDATA($B$7,"may 2004 grand total")

can "may 2004" be a cell reference

 

[kraljb]

You can do that, it would read like so:

GETPIVOTDATA($B$7, $A$1 & " Grand Total")