This function evaluates the data stored in specified fields of a specific pivot table.

Syntax

GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2],...)

Arguments

This function has the following arguments:

Argument	Description
data_field	Refers to the string data specifyng the name of the field containing the data to be retrived.
pivot_table	Refers to the string data (array, or reference to cells) to search within pivot table.
field1, item1, field2, item2	[Optional] Refers to the additional pairs of fields and item names to retrieve data for.

Remarks

If the requested arguments (or fields) are not present in the pivot table, this functions returns an error.

Data Types

Accepts only string data. Returns data of any type.

Examples

GETPIVOTDATA("Total Sales", $B$3)

GETPIVOTDATA("Product_Sales", $B$3, "Area", "North")

Version Available

This function is available in product version 11.0 or later.