Problem with getpivotdata

[AndreaColo]

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 write directli the data like "202042", if i write H3 the formula don't work..

If i do the same thing in the sheet "ordini di vendita aperti" the formula works..

What i miss?

Thanks!!

[#2 · Accepted solution]

@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.

[#3]

@Sergei Baklan Thanks a lot!

[#4]

@AndreaColo , you are welcome