Arguments of the GETPIVOTDATA Function in Excel - dummies

Arguments of the GETPIVOTDATA Function in Excel

By Stephen L. Nelson, E. C. Nelson

You can build formulas that retrieve data from a pivot table. Following is a quick description of each of the GETPIVOTDATA function arguments in Excel:

  • Data_field: The Data_field argument names the data field that you want to grab information from. For example, the Data_field name in the following figure is Sales $. This simply names the item that you drop into the Values area of the pivot table.

    The Function Arguments dialog box for the GETPIVOTDATA function.
    The Function Arguments dialog box for the GETPIVOTDATA function.
  • Pivot_table: The Pivot_table argument identifies the pivot table. All you need to do here is to provide a cell reference that’s part of the pivot table. In the GETPIVOTDATA function that used here, for example, the Pivot_table argument is $A$3. Because cell A3 is at the top-left corner of the pivot table, this is all the identification that the function needs in order to identify the correct pivot table.

    Pivot_table argument is $A$3
    The Pivot_table argument is $A$3.
  • Field1 and Item1: The Field1 and Item1 arguments work together to identify which product information that you want the GETPIVOTDATA function to retrieve. Cell C8 holds Kona Koast sales information. Therefore, the Field1 argument is Product, and the Item1 argument is Kona Koast. Together, these two arguments tell Excel to retrieve the Kona Koast product sales information from the pivot table.

  • Field2 and Item2: The Field2 and Item2 arguments tell Excel to retrieve just Oregon state sales of the Kona Koast product from the pivot table. Field2 shows the argument State. Item2, which isn’t visible in the figure, shows as Oregon.