View Single Post
  #1   Report Post  
stevec
 
Posts: n/a
Default can you use a variable or cell reference in a getpivotdata formul.

for example;

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

can "may 2004" be a cell reference