This function evaluates the data stored in specified fields of a specific pivot table.
GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2],...)
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. |
If the requested arguments (or fields) are not present in the pivot table, this functions returns an error.
Accepts only string data. Returns data of any type.
GETPIVOTDATA("Total Sales", $B$3)
GETPIVOTDATA("Product_Sales", $B$3, "Area", "North")
This function is available in product version 11.0 or later.
