Amin wants to extract data from a Pivot table he has created for items sold in the East region of his company in a year. The table contains the following entries: Cells A1, B1, A3 and B3 have the headings "Region," "East", "Items" and "Sum" in them respectively. Cells A4 to A6 has the names of Items: A3 sheets, A4 sheets and A5 sheets in them, respectively. Cells B4 to B6 had their respective selling prices. Cells B7 has the title "Grand Total" and cell C7 has the grand total of all selling prices in the table. To calculate the total for the item, A4 sheets, Amin can use the formula: =GETPIVOTDATA("Total","Product","A4 sheets").

Question

Amin wants to extract data from a Pivot table he has created for items sold in the East region of his company in a year. The table contains the following entries: Cells A1, B1, A3 and B3 have the headings "Region," "East", "Items" and "Sum"  in them respectively.  Cells A4 to A6 has the names of Items: A3 sheets, A4 sheets  and A5 sheets in them, respectively.  Cells B4 to B6 had their respective selling prices. Cells B7 has the title "Grand Total"  and cell C7 has the grand total of all selling prices in the table. To calculate the total for the item, A4 sheets, Amin can use the formula: =GETPIVOTDATA("Total","Product","A4 sheets").

Quizplus · Accepted Answer

The correct formula syntax for GETPIVOTDATA usually includes the data_field (the name of the data field to get data for), and the pivot_table argument (a reference to any cell, range of cells, or named range within the PivotTable). The formula provided in the question does not follow the correct syntax and does not specify a reference to the PivotTable. A more accurate formula might look something like =GETPIVOTDATA("Sum", $A$3, "Items", "A4 sheets"), assuming "Sum" is the data field and $A$3 is a reference within the PivotTable.

Amin Wants to Extract Data from a Pivot Table He