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

Chapter 9. Creating Knowledge Using Numbers > Creating Summaries of Your Data

Creating Summaries of Your Data

One of the most powerful tools you have for analyzing data is the PivotTable report, a feature unique to Excel. PivotTable reports allow you to create a table that summarizes and compares information in your database. PivotTables allow you to display summary information about any field in your database, such as the total amount invoiced to each client during the past year. They also allow you to show summaries by more than one field, such as the amount invoiced by client by quarter. These two-way summaries are sometimes called cross tabs. PivotTables can even compare data from a third field, by creating page fields that display the subsets of the data from that field, as shown in Figure 9-8.

Figure 9-8. PivotTable reports display cross-tabulated summary data from your database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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