Now that you've learned the role that pivot tables play in summarizing data, it's time to create your own. Before you begin, you need to have a long list of raw data that you want to summarize. You could use the customer list from the previous example, but it's too small to really show the benefits of pivot tables. A better example is something like the list of order information shown in Figure 22-4.
Figure 22-4. This worksheet shows some entries from an order list of 2,155 grocery store items. Lists like this make great pivot table candidates.