Figure 5: Sort Descending by Sales Quantity Question 5: What year had the highest Sales Quantity? 17. Remove Sales Quantity. Add Revenue. Sort Calendar Year in ascending order of Revenue. Question 6: What year had the lowest Revenue? 18. Add Material Desc. 19. Sort Calendar Year in ascending order of Revenue. Then Sort Material Desc in ascending order of Revenue. Question 7: In the year with the lowest Revenue, which Material had the lowest revenue? Question 8: Which material had the lowest revenue overall? (Hint: You may wish to remove a field to get the answer to this question.) 20. Remove Material Desc. Remove Revenue. Add Calendar Year. Add Net Sales to Values. Add Division to Rows