【How-to】How to use getpivotdata - Howto.org

In a GetPivotData formula, you refer to the pivot table, and the field(s) and item(s) that you want the data for. For example, this formula gets the Total, from the pivot table in $A$3, for the Product field, and the Paper item. =GETPIVOTDATA(“Total”,$A$3,”Product”,”Paper”)