Lab Insight: Using the same dataset as Lab $1-1,$ for Alt Lab $1-1$ calculate the gross margin by customer $($instead of SKU profitability as calculated in Lab $1-1)$ using an Excel pivot table.

Required:

Calculate total gross margin by customer for the month. $($Hint: In your pivot table, put customer # in your rows and sum of gross margin in your $\backslash$Sigma Values area$).$

Sort the gross margin by customer from high to low total gross margin.

Data: Lab $1-1$ Data.xlsx

Perform the Analysis: Refer to Lab $1-1$ in the text for detailed instruction steps.