Forum Discussion

ChristyM22's avatar
ChristyM22
Copper Contributor
Dec 16, 2021

GetPivotData does not autofill

Hello all, I have searched and have not been able to find any other instance of this happening.  I am learning how to use GetPivotData (GPV) and every reference says that if I type = and then click ...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Dec 17, 2021

Hi ChristyM22 ,

 

you are right, if you have turned on the option "Use GetPivotDate functions for PivotTable references" in the Excel options, than it should generally work.

 

But it works only, if you click on a value field in your pivot table. If you try to do it with a row or column field, it won't work.

 

Maybe you can upload a screenshot or sample file, so we could better understand the issue. 

  • ChristyM22's avatar
    ChristyM22
    Copper Contributor
    Dec 17, 2021

    Martin_Weiss Thank you so much!  I struggle with Pivot Tables to begin with, and all of the information I found about GPD all say to "click any cell in your table". Nothing specified that it had to be a value cell.  My table didn't have a value cell.  I redid the table and added a value field and it works perfectly.

    I only referenced a calculated column from the source table in the original. 

    Now I am thinking that GPD isn't the function I need for what I want to accomplish.  Back to the drawing board I guess.

     

Resources