A PivotTable is a special kind of report that rearranges the fields and records in a table into a different order so that you can examine their relationships. You pivot (in other words, rotate) the columns in a PivotTable to display the data summarized in a different way.
For example, take a look at the worksheet shown in Figure 12–1. This worksheet contains a data table that tracks sales made by a company with four product lines: Hardware, Software, Services, and Supplies. The table uses the following columns: