Returns data stored in a PivotTable report.
Cú pháp
GETPIVOTDATA(data_field, pivot_table, [field, item], …)Đối số
data_fieldbắt buộc
The name of the data field to retrieve, enclosed in quotation marks.
pivot_tablebắt buộc
A reference to any cell, range of cells, or named range in the PivotTable.
field1, item1, ...tùy chọn
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.