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.