Microsoft Office Tutorials and References
In Depth Information
PivotTables: Data Aggregation Without the Aggravation
Once you’ve compiled the data in this way
with a PivotTable, you can determine if
you’ve over- or underassigned guests to
particular tables. But you may also want to
see the data displayed as in Figure 8–3.
Figure 8–3. Who’s where: Guests identified by their
table. Note that the guest names are automatically
Here, you’ve learned exactly who’s seating where.
These are the sort of things that PivotTables (technically called PivotTable reports) can
do: they can organize—or again, break out—your data in all sorts of combinations and
modes of presentation. They’re particularly good for identifying patterns and tendencies
in the data that might otherwise escape your attention, particularly when you’re working
with a large database.
Here’s one more example, adapted from a Microsoft practice database. In this example,
you have a collection of sales records, each of which cites the salesperson, country in
which the sale was transacted, transaction date, and amount of each sale (see Figure 8–4).