Create a pivot table and chart to show the total amounts paid by year for this pharmacy, by dragging Year to the Axis Fields (Categories) box and Amount to the Values box. Be sure you are looking at the sum of Amounts in your chart. Which year had the highest sales for prescription drugs?