The Makeup2007.xlsx fi le (available for download on the companion website) gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this fi le to perform the following exercises:
a. Summarize the total revenue and units sold by each person of each product.
b. Summarize the percentage of each person's sales that came from each location. Create a PivotChart to summarize this information.
c. Summarize each girl's sales by location and use the Report Filter to change the calculations to include any subset of products.