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

S

stevec

for example;

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

can "may 2004" be a cell reference
 
K

kraljb

You can do that, it would read like so:

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