(Solved): Assignment: Case Study--Pivot Tables: Multi-Channel PharmacyYou are the marketing manager for Acme P ...

Assignment: Case Study--Pivot Tables: Multi-Channel Pharmacy

You are the marketing manager for Acme Pharmacies, a pharmacy that goes to market with three distribution channels. The channels consist of a retail store, an Internet website, and a kiosk to place orders inside of an Acme Supermarket. You want to understand how sales in the three channels compare, so you decide to create a set of pivot tables to analyze the situation from different perspectives. You assemble the data set shown in the table below

Questions:

1. Create a pivot table showing sales by product. State the total amount of sales from Product A.

2. Create a pivot table showing sales by product and by date. State the total amount of sales from Product A for the month of January.

3. Create a pivot table showing sales by product, by date, and by channel. State the total amount of sales from Product A for the month of January, sold through the website channel.