Explore BrainMass
Share

Explore BrainMass

    Pivot Table

    This content was COPIED from BrainMass.com - View the original, and get the already-completed 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 October 9, 2019, 8:05 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