GETPIVOTDATA()
Syntax. GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)
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.
Tip
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.
Arguments
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
