Chapter 12. Working with PivotTable and PivotChart Views

In this chapter

Understanding the Role of PivotTables and PivotCharts

Slicing and Dicing Data with PivotTables

Creating the Query for a Sample PivotTable View

Designing the PivotTable View of the Sample Query

Setting PivotTable Property Values

Exporting the PivotTable to Excel

Optimizing Performance of PivotTables

Formatting and Manipulating PivotCharts

Troubleshooting

In the Real World Visualizing Data