Information Data System
Sheet1
| A Sample Worksheet for the Pivot Table | |||
| Region | Salesperson | Merchandise | Amount Sold |
| Oregon | Brown | Shoes | 2000 |
| Washington | Jones | Apparels | 3000 |
| California | Adam | Cosmetics | 5000 |
| California | Jeffrey | Jewelry | 2000 |
| Oregon | Jeffrey | Jewelry | 900 |
| Washington | Adam | Jewelry | 2000 |
| Oregon | Jones | Apparels | 2000 |
| California | Jones | Cosmetics | 3500 |
| Washington | Brown | Apparels | 4500 |
| Washington | Brown | Cosmetics | 9000 |
| California | Adam | Apparels | 2000 |
| California | Adam | Cosmetics | 1500 |
| Oregon | Jeffrey | Apparels | 1700 |
| Oregon | Jeffrey | Cosmetics | 1200 |
| Oregon | Jones | Apparels | 1300 |
| California | Thomas | Cosmetics | 4000 |
| Washington | Thomas | Shoes | 2000 |
| California | Thomas | Shoes | 7000 |
| Oregon | Jeffrey | Shoes | 6000 |
| California | Adam | Cosmetics | 2000 |
| California | Brown | Apparels | 1500 |
| Oregon | Brown | Shoes | 7000 |
| Washington | Jones | Shoes | 6000 |