GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA pulls a value from a pivot by field names, not by cell position — so your report keeps working when the pivot grows or reorders. Excel writes it for you when you click a pivot cell.
Read article →