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

Your assignment is attached as the PDF. This is a simple assignment from Chapter 12. You will need to study Chapter 12 for this assignment. That is why the due date is at the end of Week 15.

The simple dataset that you will use for this assignment is also attached under assignment.

The second assignment is about Pivot Tables in Excel. Below you will find links to several tutorials on Pivot Tables:

Please note that the Pivot Tables that you need to create for your assignment are much simpler then the ones used in these YouTube videos.

Marketing Analytics: Case Studies

© Stephan Sorger, 2013; www.StephanSorger.com 1

MARKETING ANALYTICS: Case Study Name: ____________________ © Stephan Sorger 2013; www.stephansorger.com Date: ________________________

Case No. Chapters Case Title

12 12 Pivot Tables: Multi-Channel Pharmacy

Background: 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. 1. You assemble the following data set.

Customer Sales Date Product Channel

Martin Mu \$700 January Product A Retail Store

Nora Nu \$500 February Product B Website

Peter Pi \$200 February Product B Retail Store

Rhoda Ro \$600 January Product B Website

Sigmund Sigma \$800 January Product A Website

Terry Tau \$900 February Product A Kiosk

2. Create a pivot table showing sales by product. State the total amount of sales from Product A. Total amount of sales from Product A: \$__________ 3. 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. Amount of sales from Product A for January: \$__________ 4. 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. Amount of sales from Product A for January, sold through website: \$__________