Microsoft Office Tutorials and References
In Depth Information
What’s in a Name?
What’s in a Name?
PivotTables are so named because they enable the user to move, or pivot, table data to various
positions on an area called a pivot grid (you’ll see it soon), thus breaking out the data in a wide range
of changeable ways. Thus in the above case, the Expense field data occupies what’s called the Row
Labels area, the actual budget expenses are assigned to the Value area, and the Dates here are
installed in the Column Labels area. Now that’s a rather abstract description, but consider this
illustr ation, an excerpt fr om a table of sales data, adapted from one of Microsoft’s sample files, one
we’re going to work with in this chapter (Figure 8–3):
Figure 8–3. Table data—about to turn into PivotTable data
I say “excerpt” because the table—which for the purposes of this chapter we’re going to call the
Pi v otT a bl e ’ s source data -comprises one header row and 799 records (though again, the number of
records with which you work is largely irrelevant-the PivotTable concepts are the same). It’s a pretty
straightforward collection of information, recording each sale by each salesperson, date, country of
sale, order number, and sales amount. Tossing these data into a PivotTable, I could do something like
this (Figure 8–4):
Search JabSto ::

Custom Search