2007 Microsoft® Office System Inside Out

Chapter 15. 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 Office Excel 2007 list, a relational database file, an Online Analytical Processing (OLAP) cube, or multiple consolidation ranges (multiple ranges containing ...