GETPIVOTDATA

When to use it

When should I use GETPIVOTDATA?

Use GETPIVOTDATA to pull a specific value out of a PivotTable by naming the data field and filter criteria, so the reference stays stable even when the pivot layout changes.

Used in

sales

Syntax

GETPIVOTDATA(data_field, pivot_table, ...)