The ‘GETPIVOTDATA’ function is unique. As opposed to other functions, all you need to do is to click a cell.
Start a formula in cell G5.
Type the equal sign and click a cell with data within the Pivot Table. Then hit ‘Enter’.
It will look like this:
The entire ‘GETPIVOTDATA’ function is constructed for you by Excel.
This is the syntax of the function:
GETPIVOTDATA(Data_field, Pivot_location, [field1, item1, field2, item2], … )
Which turns into:
- ‘Data_field’ = Name of the field whose value is desired. In this case, “Units Sold”.
- ‘Pivot_location’ = Cell reference to the top left cell of the Pivot Table. In this case, an absolute reference to A3.
- The fields and items are extra identifiers to tell where the cell is located.