Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

GETPIVOTDATA Function

The GETPIVOTDATA function is one of the lookup and reference functions. It is used 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.

GETPIVOTDATA Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action