While working in the pivot table we will get disturbed by the GetPivotData Formula in the Pivot table while writing the formula based on the pivot table it will give the same result in the all cells
And here we have the option to turn off the GetPivotData formula option by making uncheck in the option of the GetPivotData Formula option in the Microsoft Excel
Step-1
click on the options
Step-2
and uncheck the option in Use GetPivotData Function for Pivot Table References under working with formulas
Video Link: Watch Video