The database Dish.xlsx contains a transaction history describing more than 4,000 purchases of detergent at a number of stores in a grocery chain over a period of several weeks.
a. Compile a pivot table that gives a tabulation of sales (in cases) by brand (Dove, Sunlight, and so on).
b. Compile a pivot table that gives a tabulation of sales broken down by brand and by week.
c. Compile a pivot table that gives a tabulation of sales broken down by brand, by week, and by store.
d. Compile a pivot table that gives a tabulation of the number of ounces purchased broken down by brand and by size of container. What is the sales volume in ounces for each brand?