Hi all,
Using Excel 2010
My GETPIVOTDATA() formula is returning a #REF! error.
Odd, because this works
=GETPIVOTDATA("PortionScore",$D$11,"Account","Total Revenue","SubCategory","Merchandise")
But when I change to this, I get the error :
=GETPIVOTDATA("PortionScore",'4L'!$D$11,"Account",$B3,"SubCategory",AF$3)
I have checked and rechecked the values in $B3 and AF$3 - they are definitely correct
What am I missing?
Thanks
w
Bookmarks