Microsoft Office Tutorials and References
In Depth Information
Data appropriate for a pivot table
Figure 9-3 shows another pivot table generated from the bank data. This pivot
table differs from the previous one in several ways:
The AcctType field appears as a Column Field, and the Branch field
appears as a Row field.
An additional Row field (OpenedBy) was added.
A Page field (Customer) was added.
The pivot table is formatted (using an AutoFormat) to make it more readable.
In the figure, the pivot table displays the data only for existing customers
(the user could also select New or All from Page field list).
Figure 9-3: Another pivot table generated from the bank account data
Data appropriate for a pivot table
The data that you summarize in a pivot table must start out in the form of a
database table. You can store the database in either a worksheet or an external database
file. Although Excel can generate a pivot table from any database, not all databases
benefit.
Generally speaking, fields in a database table can consist of two types:
Data: Contains a value or data to be summarized. In Figure 9-1, the
Amount field is a data field.
Category: Describes the data. In Figure 9-1, the Date, AcctType,
OpenedBy, Branch, and Customer fields are category fields because they
describe the data in the Amount field.
Search JabSto ::




Custom Search