Resolved: Hi can anybody would help me with problem
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Tables -Calculating Net Sales
I am getting 0 in the 'cost of good sold' row
formula which I am using is
=IFERROR(GETPIVOTDATA("Sum of "&$B23,pivot_financials!$A$3,"Month",D$12,"Year",D$13),0)
1 answers ( 1 marked as helpful)
Hi jee,
thanks for reaching out! You're missing an 's' in the Cost of Goods Sold column name. Is it possible that this is the reason for the error? From what I can see the rest of the calculations in the upper rows seem in order.
Let me know if there are any further issues!
Best,
365 Eli