GETPIVOTDATA

GETPIVOTDATA summary data from a pivot table

Synopsis

GETPIVOTDATA(pivot_table,field_name)

Arguments

pivot_table: cell range containing the pivot table

field_name: name of the field for which the summary data is requested

Note

If the summary data is unavailable, GETPIVOTDATA returns #REF!