Chapter 4. Changing the PivotTable View
Move a Field to a Different Area
A PivotTable is a powerful data analysis tool because it can take hundreds or even thousands of records and summarize them into a compact, comprehensible report. However, unlike most of Excel's other data analysis features, a PivotTable is not a static collection of worksheet cells. Instead, you can move a PivotTable's fields from one area of the PivotTable to another. This enables you to view your data from different perspectives, which can greatly enhance the analysis of the data. Moving a field within a PivotTable is called pivoting the data.
The most common way to pivot the data is to move fields between the row and column areas. If your PivotTable contains just a single ...