Proceed as in Problem 1, but now create a pivot table that has two fields from the

Question:

Proceed as in Problem 1, but now create a pivot table that has two fields from the Products table, Product Family and Product Department, in the Rows area and two fields from the Stores table, Country and Region, in the Columns area. Use this to find the percentage of revenue from any product family or any product department that comes from any country or any region of any country. That is, a single pivot table should answer all such questions. For example, you should find that 17.48% of all revenue from the Seafood department comes from the Central region of Mexico?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1305947542

6th edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: