GETPIVOTDATA function - Microsoft Support Since no other field is specified, GETPIVOTDATA returns the total sales amount A reference to any cell, range of cells, or named range of cells in a PivotTable This information is used to determine which PivotTable contains the data that you want to retrieve Example: =GETPIVOTDATA ("Sales", A3)