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

Data SetCustomerSalesDateProductChannelMarin Mu$700JanuaryProduct ARetail StoreNora Nu$500FebruaryProduct BWebsitePeter Pi$200FebruaryProductBRetail StoreRhoda Ro$600JanuaryProduct BWebsiteSigmund Sigma$800JanuaryProductAWebsiteTerry Tau$900FebruaryProduct AKiosk

Notes:

• US-English conventions are used for numbers. Periods (.) are used to separate whole numbers from decimals and commas (,) are used to separate thousands.
• You only have one opportunity to answer each question.

Problem 1

Build a pivot table using the data given in the case. Using the pivot table, identify the total amount of sales from Product A.

700

800

1500

2400

Problem 2

Build a pivot table using the data given in the case. Using the pivot table, identify the total amount of sales from Product A for the month of January.

700

800

1500

2400

Problem 3

0.0/1.0 point (graded)

Build a pivot table using the data given in the case. Using the pivot table, identify the total amount of sales from Product A for the month of January, sold through the website channel.

700

800

1500

2400

Problem 4

0.0/1.0 point (graded)

Build a pivot table using the data given in the case. Using the pivot table, identify the total amount of sales through the website channel.

700

800

900

1900

Problem 5

Build a pivot table using the data given in the case. Identify the ratio of sales sold through the Kiosk sales channel to total sales.

0.24

0.51

900

1900