Forum Discussion

AndreaColo's avatar
AndreaColo
Copper Contributor
Nov 09, 2020
Solved

Problem with getpivotdata

Hi,  i'm facing a issue with the formula get pivot data: In the sheet "dashboard", i'm trying to do some math using the formula getpivotdata (cell g4). The problem is that the formula work if i wr...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 09, 2020

    AndreaColo 

    There is a number in H3, it shall be convert to text to use with the function, e.g.

    =GETPIVOTDATA("residuo",'ordini di vendita aperti'!$P$15,"codice",99110001,"week calcolata",TEXT(H3,"General"))

    Same with other fields if necessary.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 09, 2020

AndreaColo 

There is a number in H3, it shall be convert to text to use with the function, e.g.

=GETPIVOTDATA("residuo",'ordini di vendita aperti'!$P$15,"codice",99110001,"week calcolata",TEXT(H3,"General"))

Same with other fields if necessary.

Resources