Microsoft Office Tutorials and References
In Depth Information
Constructing a PivotTable: Let’s Go
Figure 8–4. Sales data compiled by a PivotTable—by country and salesperson
Here the sales data are broken out by Salesperson and Country. Thus Davolio did $182,500.09
worth of business in the USA, and none in the UK (and note the original table data are formatted as
currency, but not here; the PivotTable awaits your decision on this). But I could also redesign the table
(the PivotTable that is) to take on this appearance instead (Figure 8–5):
Figure 8–5. Same data, different arrangement—the salesperson names are now running across a set of
Same exact information—but here I’ve pivoted the table, so that the Row Labels area shows the
Coun tr y data, an d the Col umn Labe l s ar e a di spl ay s the Sal e spe r son . I’ v e g i v e n the data a di ffe r e n t,
almost perpendicular look. Which look you prefer is a presentational decision, and PivotTables make
these and many other such options available.
Note as well that data from only three of the original table’s five fields have been invoked in this
PivotTable—Country, Salesperson, and Order Amount (see the Sum of Order Amount caption in the
PivotTable’s upper-left corner); that tells us that you can apply the original table fields selectively to a
PivotTable, and leave out the ones that don’t currently interest you. But nothing in PivotTables is
forever; you can start over again and introduce whichever fields you like, as your needs warrant.
But all this raises the obvious question: How do you actually start doing all this? I thought you’d
never ask. So let’s go.
Constructing a PivotTable: Let’s Go
To give PivotTables a try, download the SampleSalespersonReport workbook from our download page
at .
Let’s say you want to construct a first PivotTable, or pivot report as it’s officially termed, which
simply breaks out all sales in dollars by Salesperson. That is, we want to wind up with this report
(Figure 8–6):
Search JabSto ::

Custom Search