pivot table question

S

scott23

How can i use getpivotdata function if my pivot table has no row
field. I only use page , column , and data fields. However, i want
the use the data in the grand total of a certain data field which
happens to be a calculated field.
Thus there is no 'name' to reference since there is no row field ?

Thanks
scott
 
D

Debra Dalgleish

For a column field named "Rep", and calculated field named "Comm", the
formula in Excel 2002 would be similar to the following:

=GETPIVOTDATA("Sum of Comm",$A$3,"Rep","Morgan")

or in Excel 2000:

=GETPIVOTDATA(Pivot!$A$1,"Rep Morgan 'Sum of Comm'")
 
Top