GETPIVOTDATA (data_field, pivot_table,, …) Let’s understand the syntax of GETPIVOTDATA () function
How to toggle (turn on/turn off) the GetPivotData feature OR, use the Generate GetPivotData command to turn this feature off. If you prefer to use a cell reference, you can type the reference, e.g. If you have the Generate GetPivotData feature turned on, this formula will be created automatically, when you reference a cell in a Pivot Table. $D$9 then the value will change if the layout is changed as it refers to that particular cell only. If you give reference to a cell by typing the cell i.e. To enter the formula you can type equal to (=) and click on the specified cell in the pivot table. With the help of GETPIVOTDATA we can extract correct data from the Pivot table even if the pivot table layout is changed as it uses criteria to lookup. You need not create a pivot table every time.
Sometimes the management may request for different set of reports summarized based on different conditions. The magic of GETPIVOTDATA () will protect your values ….
