The P04_03.xlsx file contains four tables on four separate sheets with information about a companys sales in

Question:

The P04_03.xlsx file contains four tables on four separate sheets with information about a company’s sales in the latter part of 2018. These tables are not currently related, but they are relatable through key “ID” fields. Create a pivot table based on any of the tables—you can decide which—and check the option to add this to a Data Model. Then add fields from all the tables to the pivot table, creating relationships when necessary. (That is, mimic Example 4.2.) Manipulate the pivot table to find the Sum of QuantityOrdered, broken down by month of OrderDate and ProductName, but only for products in the Clothing category. Finally, after checking in the Power Pivot window that the tables are related correctly, delete the original four sheets. Your pivot table should still work fine.

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: 9780357109953

7th Edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: