Resolved: Dashboard in excel- Tables- Calculating net sales
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Tables -Calculating Net Sales
Hello good day, please could you explain why you copied the formula from volume and pasted in net sales & cost of goods sold. I'm a bit confused there. Thanks
1 answers ( 1 marked as helpful)
Hi Roman,
thanks for reaching out! The key here is to fix the appropriate cells, when working on the first formula - that of Volume. We fixed the Column B, in the B16 cell, so when we copied it and placed it in the Net Sales row for example, the column B stayed fixed but the row changed - it is now showing B20 and the formula becomes Sum of Net Sales.
If you're interested in learning even more about working with Excel and Pivot tables, you can check out our course on just that topic:
Data Analysis with Excel Pivot Tables
Let me know if you have any further questions!
Best,
365 Eli