GETPIVOTDATA
Returns data stored in a PivotTable report.
Lookup & ReferenceLookup & Matching Essentials
What it does
Extracts data from a PivotTable based on field names, robust to layout changes.
Syntax
GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...)
Arguments
data_field(text) — Name of the value field to query.pivot_table(reference) — Reference to any cell in the PivotTable.
Examples
Query PivotTable
Get 'Sales' for 'North'.
FORMULA
=GETPIVOTDATA("Sales", $A$3, "Region", "North")RESULT
1500
SAMPLE DATA
| A | |
|---|---|
| 1 | (Pivot Table) |
| 2 | (Region/Sales data) |