Excel 2007


Creating Pivot Tables
Challenge!
Use the Company Sales workbook to complete this challenge.
- Create a PivotTable report that calculates the amount each salesperson sold.
- Filter the report by region.
- View the data for the salespeople in the North and West region.
- Who sold the greatest dollar amount in these two regions?