Pivot Tables are a powerful reporting tool that let you organize data in a summarized fashion.
To learn how to create a Pivot Table widget, see Adding a Pivot Table.
Examples
Consider the following raw data:
| Product | Customer | Sales |
| Shirt | John | 10 |
| Shirt | Mary | 20 |
| Pants | John | 30 |
| Pants | Mary | 40 |
Possible Pivot Tables from this data are:
| [Product] | [Sum Sales] | [Avergage Sales] | [Count Customers] |
| Shirt | 30 {10+20} | 15 {(10+20)/2} | 2 |
| Pants | 70 {30+40} | 35 {(30+40)/2} | 2 |
| [Customer] | [Sum Sales] | [Avergage Sales] | [Count Products] |
| John | 40 {10+30} | 20 {(10+30)/2} | 2 |
| Mary | 60 {20+40} | 30 {(20+40)/2} | 2 |
See Also