Introducing PivotTables

Creating a PivotTable

Rearranging PivotTable Fields

Refreshing a PivotTable

Changing the Numeric Format of PivotTable Data

Choosing Report Layout Options

Formatting a PivotTable

Displaying Totals and Subtotals

Sorting PivotTable Fields

Filtering PivotTable Fields

Changing PivotTable Calculations

Grouping and Ungrouping Data

Displaying the Details Behind a Data Value

Creating PivotCharts

A PIVOTTABLE report is a special kind of table that summarizes information from selected fields of a data source. The source can be a Microsoft Excel 2010 list or table, a relational database file, or an online analytical processing (OLAP) cube. When you create a PivotTable, you specify which fields you’re interested in, how you want the table organized, and what kinds of calculations you want the table to perform. After you build the table, you can rearrange it to view your data from alternative perspectives. This ability to “pivot” the dimensions of your table—for example, to transpose column headings to row positions—gives the PivotTable its name and its analytical power.