Create a PivotTable to show the total sales by sales person for the years $2016$ and $2017.$

Insert the PivotTable on the Revenue worksheet.

Place SalesPerson as the row labels.

Place Date as the column labels.

Show only the year totals.

Use an appropriate presentation of the Dollars field as the PivotTable values to display the total sales.

Use the Filter element to filter the PivotTable column labels to display the years $2016$ and $2017.$

Turn off the grand totals for rows and columns on the PivotTable.