The first argument,data_field, names a value field to query.

The second argument, pivot_table, is a reference to any cell in an existing pivot table.

The second argument is a reference to a cell that is part of the pivot table.

Example of GETPIVOTDATA function with a pivot table

Example of GETPIVOTDATA function with a pivot table

Example of GETPIVOTDATA function with a pivot table

Example of GETPIVOTDATA function with a pivot table

Example of GETPIVOTDATA function with a pivot table

Excel formula: Get pivot table grand total

Excel formula: Get pivot table subtotal grouped date

Excel formula: Get pivot table subtotal

Example of GETPIVOTDATA function with a pivot table