GETPIVOTDATA
Returns data stored in a PivotTable report
Syntax
GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...)
Parameters
- data_field: Required. The name, enclosed in quotation marks, for the data field that contains the data you want to retrieve
- pivot_table: Required. A reference to any cell, range of cells, or named range of cells in a PivotTable report
- field1: Optional. The name of a field to reference
- item1: Optional. The item in the field to reference
Example
=GETPIVOTDATA("Sales", A3, "Region", "East")