Forum Discussion
Solved
GET PIVOTDATA #REF! error
I am frustrated! I have posted this question 2 times, but it never appears in my conversations on the community. Trying again. I want to use the GET PIVOTDATA function to reference data from wi...
Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")
Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")
Hi Jan, I have a similar question except instead of returning a text value, I need to return a blank field from the pivot table as a number. The pivot table contains information about sales by each salesperson. Since some of the salespeople are new, there is blank (null?) data in some of the months and when I try to reference the sum of that particular month in my calculation, it returns an #REF! error. The formula is =GETPIVOTDATA("Total Ext. Price",$A$3,"SO Month",1). I've made sure the pivot table number format is a number.