GETPIVOTDATA Function Explained
The GETPIVOTDATA Function in Microsoft Excel is used to retrieve data stored in a PivotTable. It takes a reference to a PivotTable cell and returns the corresponding value from the PivotTable. It can also be used to retrieve data from a PivotTable based on specific criteria.
GETPIVOTDATA Function Syntax
GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)
- data_field: The data field that contains the data you want to retrieve.
- pivot_table: The range of cells that make up the pivot table.
- field1, item1: The field and item pair that you want to use to filter the data.
- field2, item2: (Optional) An additional field and item pair that you want to use to filter the data.