Getting a Ref! Error when trying to modify GETPIVOTDATA funtion
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Tables -Calculating Net Sales
Im trying to figure out why this the function is not working , its almost identical to the videos intruction but is not working so i try to check just the function without the iferror to see the error and it said is a ref error ,i would like some help with cause im not sure whats the problem ,thank you so much
1 answers ( 0 marked as helpful)
Hi Carlos,
thanks for reaching out! Is it possible that the error is caused because you've entered volume with a small v, instead of the capital Volume? Otherwise the formula seems in order.
Let me know if this works.
Best,
365 Eli