Last answered:

23 Mar 2023

Posted on:

22 Mar 2023


Resolved: 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)
Posted on:

23 Mar 2023


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!


365 Eli

Submit an answer