GetPivotData In Excel

We can add two GetPivotData in Excel. For instance, we have the following pivot table in Excel.



To get the sales value of region ‘East’ and product category ‘Office Supplies’, we can apply the following GetPivotData function.



Assume we need to get the sales of the regions ‘East’ & ‘West’ and for the product category ‘Technology’ we can apply GetPivotData functions in one.



In the item argument of the region field, we have applied two regions East and West, in curly brackets and then surround the GetPivotData function in the SUM function.

We can also apply two GetPivotData functions and add them together to the result.



After the first GetPivotData function, we added plus symbol and then applied another GetPivotData function to get the same result as the previous one.

By default, when we select any of the cells in the pivot table, the GetPivotData function will be automatically applied as shown in the following image.



However, we can disable this with just a click.

Select any of the cells in the pivot table, and it will activate Pivot Table Analyze tab. Under this tab, click on the Pivot Table drop-down and also click on the Options drop-down.



As we can see in the above image, Generate GetPivotData is enabled. Click on this option, and the tick mark disappears, as shown in the following image.



Now, if we select any of the cells in the pivot table, Excel no longer applies the GetPivotData function automatically.

Type an equal sign in any of the cells in the new sheet and go to the pivot table sheet and choose any of the cells in the pivot table. The moment we choose a cell in the pivot table, it will automatically insert GetPivotData in excel.

From the detailed summarized report, sometimes we may have to look at only one specific record, so in these cases we use GetPivotData in excel.