Returns data stored in a PivotTable report.
Syntaxe
GETPIVOTDATA(data_field, pivot_table, [field, item], …)Arguments
data_fieldobligatoire
The name of the data field to retrieve, enclosed in quotation marks.
pivot_tableobligatoire
A reference to any cell, range of cells, or named range in the PivotTable.
field1, item1, ...facultatif
Pairs of field names and item names that describe the specific data to retrieve.
The GETPIVOTDATA function is used to retrieve specific summary data from a PivotTable. It ensures that your formulas remain accurate even if the layout of the PivotTable changes, provided the data exists in the report.
=GETPIVOTDATA("Sales", $A$3, "Region", "North")→15000Retrieves the total Sales for the North region from the PivotTable starting at cell A3.
Select the cell
Click the cell where you want to display the retrieved data.
Enter the formula
Type =GETPIVOTDATA and provide the data field name and a reference within the PivotTable.
This usually happens if the specified field or item does not exist in the PivotTable.