Assignment Help-Business Analysis

Assignment Help-Business Analysis

The XYZ Company sells different merchandise through different salespersons in different states. The sales manager is interested in knowing who sold what, where, and how much. Using the sample data construct a pivot table for each of the items below:

1. Sum of Amount Sold
2. Total sales broken down into three regions
3. Performance of each salesperson in each region
4. Sales broken down by region, then by salesperson, and then by Merchandise
5. Two-dimensional table that shows sales performance by region and type of merchandise