Chapter 23. Analyzing Data with PivotTable Reports

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 ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.