Fine Shirt Company would like to know how many units of its products designed for each gender

Question:

Fine Shirt Company would like to know how many units of its products designed for each gender subset (i.e., men, women, and both genders) were sold to each customer during each quarter of the past five years (i.e., from the first quarter of 2012 through the fourth quarter of 2016). Starting with the file Shirt Orders.mdb from Example 18.5, perform an appropriate query and bring the results back to Excel as a pivot table to answer the company's question?

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: