Requirements

For each of the situations listed below, assume that you would create a pivot table from

the open orders data set to answer the question. In this exercise, profitability is

measured by total gross profit. Indicate which field you would use for the Rows box,

which field $($if any$)$ you would use for the Columns box, and which field you would use

for the Values box. Also indicate how you would sort the pivot table. $($Note: You do not

need to create the pivot table in Excel in this exercise.$)$

How much gross profit will be generated by the open orders for each product size?

Which product size is the most profitable?

How much gross profit will be generated by the open orders for each customer?

Which customer is the most profitable?

How much gross profit will be generated by the open orders in each city? Which

cities are the most profitable?

How much gross profit will be generated by each product size within each city?

How much gross profit will be generated by each customer within each city?

Worksheet