You need the Pivot table to show you the overall sales total and the amount achieved by each person on the team. You also want to be able to see what percentage of the overall total each salesperson achieved, and you need to be able to filter by their name. You will be dragging the headings into the Pivot Table Task Pane.