GETPIVOTDATA
Formulas / GETPIVOTDATARetrieve data from a pivot table by name.
GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)
- data_field - required, name of the data column in the PivotTable that contains the data to retrieve
- pivot_table - required, reference to any cell, range of cells, or named range of cells in a PivotTable
- field1, item1, field2, item3... - [OPTIONAL] 1 to 126 items, describes the data to retrieve
Examples
=GETPIVOTDATA("Sales",$B$4,"Product","Hazelnut")The GETPIVOTDATA function can be used to retrieve specific data from a pivot table. For example, the following formula will return the total sales for the product Hazelnut, which in this case is 62456.
GETPIVOTDATA("Sales",$B$4,"Region","East","Product","Almond")The GETPIVOTDATA function can also be used to retrieve data based on multiple criteria. For example, the following formula returns the total sales for the Product Almond in the East region, which in this case is 41518.
Summary
The GETPIVOTDATA function is used to retrieve data from PivotTables, which is a Sourcetable table containing pivot rows and columns. This function takes three arguments, which specify the data to be retrieved, it can be a single cell or a list of cells.
- The GETPIVOTDATA function requires a reference to a value field in order to return data, as well as additional arguments to specify a field/item pair.
Frequently Asked Questions
What is the GETPIVOTDATA function?
The GETPIVOTDATA function retrieves visible data from a PivotTable. This function takes a PivotTable field as an argument, which describes the data to be retrieved from the PivotTable.
What is the format of the data returned by the GETPIVOTDATA function?
The GETPIVOTDATA function returns the data in a table of parameters.
What are the arguments that the GETPIVOTDATA function takes?
The GETPIVOTDATA function takes a PivotTable field as its argument, which is required. This argument describes the data to be retrieved from the PivotTable.
What is the purpose of using the GETPIVOTDATA function?
The GETPIVOTDATA function is used to retrieve visible data from a PivotTable.
