Looking at quantities

Let us view the total sales by average quantity. Many customers buy a single quantity of a product but combine that with other product types. The average quantity differs when calculated at the invoice level vs. across the entire business. This exercise will help solidify your understanding of the relationship between the shipped quantity and the shipping cost.

We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_4_order_metrics_solution.pbix from the Workbooks folder.