Microsoft Office Tutorials and References
In Depth Information
PivotTables: Data Aggregation Without the Aggravation
Figure 8–4. Salesperson data, ripe for pivot tabling
One obvious question you might want to
ask of the data is: how much money each
salesperson earned? A PivotTable will tell
you (see Figure 8–5).
Figure 8–5. Salesperson earnings, with the grand total
There’s your answer—or at least one answer. But with PivotTables, you can also come
up with something like what’s shown in Figure 8–6.