Forum Discussion
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 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!!
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 Replies
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 Thanks a lot!
AndreaColo , you are welcome
