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

A Simple Example

Figure 30-1 shows a list of sales figures for a small publishing firm. The list is organized by year, quarter, catalog number, distribution channel, units sold, and sales receipts. The data spans a period of eight quarters (1999 and 2000), and the firm uses three distribution channels—domestic, international, and mail order. With just a few keystrokes you can turn this “flat” list into a table that provides useful information at a glance. One of the many possible arrangements for this PivotTable is shown in Figure 30-2.

Figure 30-1. It's difficult to see the bottom line in a flat list like this; turning the list into a PivotTable will help.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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