[HW 2.5c] Pivot Tables – Part 1

Using this dataset, please prepare a report that answers the following questions.  The format should look something like this:

pivot

1. Over the entire analysis period, what was the quantity of item 10 sold while John Jones was the Manager on duty?

2. Over the entire analysis period, what were the 3 highest selling items by quantity?

3. Over the entire analysis period, which sales person sold the highest cumulative quantity of a single item, and which item was it?

4. What was sales person Wendel’s total Sales over the analysis period?

5. How many invoices did sales person Sally create over the analysis period?

6. During the month of May, which postal code bought the most of item 5 by quantity?

7. During the month of February, how many postal codes bought more than 400 products by quantity?

8. Over the entire dataset, which 3 items did Postcode 3020 spend the greatest dollars on?

 

20150110.dataset.MO13R2Q2

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: