Task: The database DISH.XLS 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.
Q1. Compile a pivot table that gives a tabulation of sales (in cases) by brand (Dove, Sunlight etc.)
Q2. Compile a pivot table that gives a tabulation of sales broken down by brand and by week.
Q3. Compile a pivot table that gives a tabulation of sales broken down by brand, by week and by store
Q4. 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?
Attachment:- dish.xls