GETPIVOTDATA
 

I used GETPIVOTDATA on a pivot table to show totals of different groups of
data. The formula I used is as follows:=GETPIVOTDATA(PT1,"Sum of SalesTotal
CG PIES"). If I change the "PIES" to other groups within the pivottable it
result in #N/A. Some groups work and others not. I even refernece the name
directly in the table, but still get a #N/A.
has anyone any suggestions please.