Excel GETPIVOTDATA function

Function              GETPIVOTDATA

Description        Excel GETPIVOTDATA function extracts data from a pivottable.

Syntax  GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,…)

data_field  The name of the value field to be queried in pivottable.

pivot_table  A reference to any cell in the pivot table to be queried in pivottable.

field1, item1  [optional] A field and item to be input in pair.

Example:

Usage Notes:

• The name of the data_field, and field/item values must be write within double quotes.
• Excel GETPIVOTDATA function will return a #REF error if any fields name input are wrong.