Part IV: Managing and Analyzing Data
FIGURE 29.2
A simple PivotTable
FIGURE 29.3
A PivotTable that uses a report filter
Notice the change in the orientation of the table? For this PivotTable, branches appear as
column labels, and account types appear as row labels. This change, which took about five
seconds to make, is another example of the flexibility of a PivotTable.
Why Pivot?
Are you curious about the term pivot?
Pivot, as a verb, means to rotate or revolve. If you think of your data as a physical object, a PivotTable lets
you rotate the data summary and look at it from different angles or perspectives. A PivotTable allows
you to move fields around easily, nest fields within each other, and even create ad hoc groups of items.
