Definition. This function returns data from a PivotTable report. You can use GETPIVOTDATA() to retrieve summary data from a PivotTable report as long as the summary data is visible in the report.
You can quickly enter a simple GETPIVOTDATA() formula by typing = in the cell to which you want to return the value and then clicking the cell in the PivotTable report that contains the data you want to return.
data_field (required) The name, enclosed in quotation marks, for the data field that contains the data that you want to retrieve.
pivot_table (required) A reference to a cell, cell range, or named cell range in a PivotTable report. This information ...