Description
GETPIVOTDATA function fetches summary data from a pivot table. @pivot_table is a cell range containing the pivot table. @field_name is the name of the field of which you want the summary data.
If the summary data is unavailable, GETPIVOTDATA returns #REF! error.