Feb 09 2022 03:19 PM
Hello,
I am trying to use a Getdata formula that works when I use 1 field of criteria ("Size Name") but when I add a second field "Variant" it returns a #REF!. Below is a list of things I have tried but haven't worked.
1. Change "'DATA BASE'!B33" to 20 (This is the value in the cell)
2. Change formatting on my data to match the pivot
3. Change all formatting to general.
4. Added and removed "Size Name" and "Variant" from Pivot
5. Tried the formula just with ""Variant",20" and with ""Variant",'DATA BASE'!B33"
I am at a loss. Any help would be appreciated.
Thanks
Ry
=GETPIVOTDATA("Sum of 01/2022",'PM Only Pivot'!$A$9,"Size Name",$C23,"Variant",'DATA BASE'!B33)
Feb 09 2022 11:46 PM
Hi @ryanpayne ,
if the cell B33 contains numbers, try this one:
=GETPIVOTDATA("Sum of 01/2022",'PM Only Pivot'!$A$9,"Size Name",$C23,"Variant",TEXT('DATA BASE'!B33,"#"))
Feb 10 2022 07:35 AM
Feb 10 2022 11:17 PM
Hi @ryanpayne
is this second criteria really visible in the Pivot table?
GETPIVOTDATA can refer only to values that are currently visible.