Home > Articles

  • Print
  • + Share This
This chapter is from the book

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 is the text string enclosed in double quotes or referenced as your lookup criteria.

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.

  • + Share This
  • 🔖 Save To Your Account