Microsoft Office Tutorials and References
In Depth Information
A pivot table example
interactivity. After you create a pivot table, you can rearrange the information in
almost any way imaginable. You can even create custom groupings of summary
items (for example, combine Northern Region totals with Western Region totals).
As far as I can tell, the term pivot table is unique to Excel. The name stems from
the fact that you can rotate (that is, pivot) the table’s row and column headings
around the core data area to give you different views of your summarized data.
One minor drawback to using a pivot table is that, unlike a formula-based
summary report, a pivot table does not update automatically when you change the
source data. This drawback does not pose a serious problem, however, because a
single click of the Refresh toolbar button forces a pivot table to update and use the
latest data.
A pivot table example
Perhaps the best way to understand the concept of a pivot table is to see one. Start
with Figure 9-1, which shows a portion of the data that I’m using to create a pivot
table.
Figure 9-1: This database is used to create a pivot table.
This database consists of daily new-account information for a three-branch
bank. The database contains 1,908 records (rows), representing the new accounts
opened in one month. Each record contains information for the new account that
was opened. The data collected consists of the following:
The date that the account was opened
The account type (CD, Checking, Savings, or IRA)
The opening dollar amount
Search JabSto ::




Custom Search