1. In the year that had the highest Net Sales, what division and customer had the highest Net Sales?

1. In the year with the lowest Net Sales, what division and customer had the highest Net Sales?

1. What customer provided the highest Net Sales for Accessories (AS Division) in all years?

Question 8: In the year that had the highest Net Sales, what division and customer had the highest Net Sales? Hint: You will have to add a field and perhaps a filter and then sort. Question 9: In the year with the lowest Net Sales, what division and customer had the highest Net Sales? Hint: Remove any filters you may have applied to answer the previous question. Question 10: What customer provided the highest Net Sales for Accessories (AS Division) in all years? Hints regarding removal of filters will no longer be given in some cases. Therefore, you will want to watch carefully and be sure to remove filters after they are no longer needed. 11. Include only Calendar Year, Division and Customer Desc in Filters or Rows. Include only Net Sales in Values. a. Filter Year to 2019, Division to BI. b. Click on any customer and then Row Labels 7 Value Filters 7 Top 10 7 enter 3 (to filter to the top 3). Question 11: In 2019, for Bicycles (Division is BI), what is the total Net Sales for the top three customers? 12. Remove the Top 3 filter. Remove the Calendar Year filter. Remove the Division Filter. 13. Right-click Sum of Net Sales in the crosstab. Change the Summarize by to Average