Nov 09 2020 09:36 AM
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!!
Nov 09 2020 01:09 PM
SolutionThere 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.
Nov 09 2020 01:09 PM
SolutionThere 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.