Use JPivot to answer the following questions:
| Questions | Answer | Hint | |
| 1. | What were unit sales for all products across all media? | 266,773 |
Click on JPivot pivot table |
| 2. | What were unit sales for food? | 191,940 |
Click on + besides Food (drill down) |
| 3. | What were the units sales for Gorilla 1% milk | 160 |
Drill down on Dairy |
| 4. | What were unit sales for those with a graduate degree | 15,570 | Open OLAP navigator (left most button) |
| 5. | What were units sales for Gorilla 1% milk females with a graduate degree | 4 | |
| 6. | What unit sales of carbonated beverages can be attributed to bulk mail promotion? | 3 |
Experiment with JPivot to learn how to rotate a display and other use other features.
This page is part of the promotional and support material for Data Management (fifth edition) by Richard T. Watson |