• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 9: Managing Databases and Lists > Analyzing Data with PivotTable Reports

Chapter 30. Analyzing Data with PivotTable Reports

A Simple Example 797

Creating a PivotTable 800

Pivoting a PivotTable 804

Creating a PivotChart 806

Refreshing a PivotTable 808

Selecting Elements of a PivotTable 808

Formatting a PivotTable 809

Using Multiple Data Fields 811

Renaming Fields and Items 812

Sorting Items 812

Showing the Top or Bottom Items in a Field 814

Hiding and Showing Inner Field Items 814

Displaying the Details Behind a Data Value 815

Grouping and Ungrouping Data 816

Using Grand Totals and Subtotals 819

Changing a PivotTable's Calculations 821

Referencing PivotTable Data from Worksheet Cells 827

Creating a PivotTable from External Data 827

Using a PivotTable to Consolidate Ranges 830

Building a PivotTable from an Existing PivotTable 835

Printing PivotTables 835

Using the PivotTable Web Component 836

A PivotTable Report is a special kind of table that summarizes information from selected fields of a data source. The source can be an Excel list, a relational database file, an OLAP cube, or multiple “consolidation ranges” (multiple ranges containing similar data, which the PivotTable can assemble and summarize). 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 have built 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 unusual analytical power.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint