`GETPIVOTDATA`

`GETPIVOTDATA` returns a value of data stored in a PivotTable.

=GETPIVOTDATA(pivot_table,name)

The

`pivot_table`argument refers to the pivot table that contains the data you want to retrieve. This can be a reference to any cell within the pivot table or a named range that refers to the pivot table.The

*name*

The `GETPIVOTDATA` function can extract total sums from a pivot table
or pull multiple sets of data and find the information at their intersecting
points. For example, notice the pivot table in Figure
3.10. The months are shown down the left side and the years across the top.
The formula to look up a grand total for the year 2000 is simply

=GETPIVOTDATA(E4,"Sum of 2000")

In this formula, E4 selects the entire PivotTable, and "Sum of 2000" in quotations is the column heading. To look up information at intersecting points, such as the sum of August for the year 2000, this is not case sensitive. The formula would read

OK=GETPIVOTDATA(E4,"Aug Sum of Sales")

**Figure 3.10 The GETPIVOTDATA
function can be used to extract total sums or to find the intersecting points
of sets of data.**