Excel Function : GETPIVOTDATA

Download now!

Excel Function : GETPIVOTDATA

Category

Lookup and reference

Description

Returns data stored in a PivotTable report

Microsoft Excel Reference Page

https://support.office.com/en-us/article/GETPIVOTDATA-function-8c083b99-a922-4ca0-af5e-3af55960761f

Syntax and Description of the GETPIVOTDATA Excel Function

The syntax for GETPIVOTDATA is as follows: GETPIVOTDATA(data_field, pivot_table, [field1, item1], [field2, item2], ...) The arguments for this function are as follows: - data_field: This is the name of the data field that you want to retrieve data for. - pivot_table: This is the reference to the pivot table that contains the data you want to retrieve. - field1, item1, field2, item2, ...: These are the field and item pairs that you want to use to filter the data.

About GETPIVOTDATA Excel Function

The GETPIVOTDATA function in Excel returns data stored in a pivot table. The function is used to extract data from a pivot table based on a given criteria. The syntax for the function is as follows: GETPIVOTDATA(data_field, pivot_table, [field1, item1], [field2, item2], ...) The data_field argument is the name of the data field that you want to extract data from. The pivot_table argument is a reference to the pivot table that contains the data. The field1, item1, field2, item2, ... arguments are used to specify the criteria for extracting data from the pivot table.