Explore BrainMass
Share

Pivot Table

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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.

a. Compile a pivot table that gives a tabulation of sales (in cases) by brand (Dove, Sunlight etc.)
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?

© BrainMass Inc. brainmass.com September 25, 2018, 3:09 pm ad1c9bdddf - https://brainmass.com/economics/break-even-analysis/pivot-table-138908

Attachments

Solution Summary

The excel file contains Pivot tables with excel sheets named as per sub-questions and the word document contains step by step instructions to create Pivot tables.

$2.19