Understanding What PivotTables Are and What You Can Do with Them
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:
- Sale. A unique sequential number used to identify each sale.
- Year, Month, and Day. The year, month, and day of the sale. Having these items in separate columns makes it ...
Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
