In this scenario, you're managing sales data for a hardware store. Because there is so much data, you'll want to use PivotTables to create easy$-$to$-$read reports. Perform the following tasks:

Create a PivotTable based on A$1$:H$31$ of the Sales Data worksheet, placing the table on a new worksheet. Using this PivotTable, create a report that shows the total sales of each salesperson, grouped by region.