The database Dish.xlsx contains a transaction history describing more than 4,000 purchases of detergent at a number

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: