GETPIVOTDATA
Description
Returns related data from a pivot table without directly referencing cells. Using this
function instead of a cell reference preserves the data if the pivot table changes in the
future. You can include multiple fields and items.
Syntax
GETPIVOTDATA(
data_field
,
pivot_table
, [
field1
,
item1
,
field2
,
item2
], ...)
- data_field: The pivot summary value field name or display label.
- pivot_table: A pivot table cell or range reference.
- field1: A row or column pivot field name or display label.
- item1: The corresponding row or column pivot field value.