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'")

scott23 wrote:
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 ?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html