GETPIVOTDATA Function
The GETPIVOTDATA function is one of the lookup and reference functions. It is used to extract data stored in a PivotTable.
Syntax
GETPIVOTDATA(data_field, pivot_table, [field], [item], …)
The GETPIVOTDATA function has the following arguments:
| Argument | Description |
|---|---|
| data_field | Is used to set the name of the PivotTable field that contains the required data. The argument needs to be in quotes. |
| pivot_table | Is used to refer to any cell, range of cells, or named range of cells in a PivotTable. The argument is used to determine which PivotTable contains the required data. |
| field, item | A field/item pair. There are up to 126 pairs of field names and item names that may be used to describe the required data. The pairs can be in any order. |
Examples
The figure below displays the result returned by the GETPIVOTDATA function.
