Microsoft Office Tutorials and References
In Depth Information
Adding Data Fields
Figure 8–21. Adding a third field to the pivot report
(Before you continue, you may want to Autofit the first column (by double-clicking the right
boun dar y of col umn A), so that the phr ase Sum of Or de r Amoun t be come s compl e te l y v i si bl e .) He r e
we’ve done something new; we’ve placed two fields in the same area, in this case Row Labels. And
what happens as a result should be pretty clear: the Country field serves as a kind of super category
within which the Salespersons are housed, to go on and break out the data further. Thus what we’ve
done is learn how much sales activity has been conducted in the respective countries, by the respective
salespersons ; an d be ar i n mi n d that i f an y Sal e spe r son had con ducte d busi n e ss i n both coun tr i e s
(a l thoug h tha t i sn ’ t the ca se he r e ), hi s n a me woul d ha v e a ppe a r e d wi thi n both the UK and USA super
categories.
You’ve also probably noticed the minus signs flanking the UK and USA items in the Country field.
Clicking either or both collapses the subcategory data for each country, for example (Figure 8–22):
Figure 8–22. Economic collapse, of sorts—collapsing the UK sales data
Click what is now the plus sign and the Salesperson data reappear. You can also execute this
command by clicking in the now-collapsed UK row and then clicking PivotTable Tools Options tab
Active Field , and clicking the accompanying plus and/or minus signs (Figure 8–23):
Search JabSto ::




Custom Search