[HW 3.2c] Pivot Tables – Part 2

Using this same dataset that you used previously, please prepare a report that answers the following questions.

Again, the format should look something like this:

pivot
9. What is the rank of sales persons from highest to lowest based on the number of invoices written during the month of May?

10. What was the invoice number of the largest invoice by revenue that sales person Wendel wrote during the analysis period?

11. Over the entire analysis period, what is the rank of sales persons according to the dollar value of discounts given, from most discounts to least discounts?

12. Which month had the highest revenue?

13. Only considering postal codes 3013, 3017 and 3031, which item had the highest total profit during the month of February?

14. What is the rank of months from highest to lowest based on profit over the entire analysis period?

15. During which 3 months did manager John Jones have the highest cumulative profit ignoring all sales to postal codes 3019 and 3028 and ignoring all sales of items 4, 5, 6, 17 and 18?

16. What quantity of item 3 was sold by sales persons Benny and Kelly together during the month of June?
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: