Explanation
To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level.
In this case, we want the grand total of the "sales" field, so we simply provide the name the field in the first argument, and supply a reference to the pivot table in the second:
=GETPIVOTDATA("Sales",$B$4)
The pivot_table reference can be any cell in the pivot table, but by convention we use the upper left cell.
Note: GETPIVOTDATA will return the value field based on current "summarize by" settings (sum, count, average, etc.).
Related formulas
Get pivot table subtotal
To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level. In this case, we want a subtotal of the "sales" field, so we provide the name the field in the first argument, and supply a reference to the pivot table in the...
Get pivot table subtotal grouped date
To use the GETPIVOTDATA function, the field you want to query must be a value field in the pivot table, subtotaled at the right level. When dates are grouped, they can be queried based on the numeric equivalent: Grouped by month - use numbers 1-12 Grouped by quarter - use numbers 1-4 Grouped by...
Related functions
GETPIVOTDATA Function
The Excel GETPIVOTDATA function can retrieve specific data from a pivot table by name based on the structure, instead of cell references.
