SOLVED

Problem with getpivotdata

%3CLINGO-SUB%20id%3D%22lingo-sub-1867870%22%20slang%3D%22en-US%22%3EProblem%20with%20getpivotdata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867870%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20facing%20a%20issue%20with%20the%20formula%20get%20pivot%20data%3A%3C%2FP%3E%3CP%3EIn%20the%20sheet%20%22dashboard%22%2C%20i'm%20trying%20to%20do%20some%20math%20using%20the%20formula%20getpivotdata%20(cell%20g4).%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20the%20formula%20work%20if%20i%20write%20directli%20the%20data%20like%20%22202042%22%2C%20if%20i%20write%20H3%20the%20formula%20don't%20work..%3C%2FP%3E%3CP%3EIf%20i%20do%20the%20same%20thing%20in%20the%20sheet%20%22ordini%20di%20vendita%20aperti%22%20the%20formula%20works..%3C%2FP%3E%3CP%3EWhat%20i%20miss%3F%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1867870%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868842%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20getpivotdata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868842%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F862929%22%20target%3D%22_blank%22%3E%40AndreaColo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20is%20a%20number%20in%20H3%2C%20it%20shall%20be%20convert%20to%20text%20to%20use%20with%20the%20function%2C%20e.g.%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DGETPIVOTDATA(%22residuo%22%2C'ordini%20di%20vendita%20aperti'!%24P%2415%2C%22codice%22%2C99110001%2C%22week%20calcolata%22%2CTEXT(H3%2C%22General%22))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ESame%20with%20other%20fields%20if%20necessary.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!!

3 Replies
best response confirmed by AndreaColo (New Contributor)
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.

@Sergei Baklan Thanks a lot!

@AndreaColo , you are welcome