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.

Alla pagina precedente