(Based on the Northwind database) Create an appropriate query and return it as a pivot table. This...

Question:

(Based on the Northwind database) Create an appropriate query and return it as a pivot table. This pivot table should allow you to see the number of orders shipped by each shipper during each month.

For example, you should find that the shipped date was July 1997 for 13 orders shipped by Speedy Express. (Note: Microsoft Query recognizes primary key-foreign key relationships if the primary key and foreign key have the same name. However, it doesn't recognize the relationship in this case because the primary key is ShipperID and the foreign key is ShipVia. Therefore, you must drag a link between these two in the top pane of the Microsoft Query screen.)

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: