Microsoft Office Tutorials and References
In Depth Information
Moving and Removing Fields
Here you’re presented with a wide assortment of options for describing your data comparatively,
for example, how each salesperson’s sales total ranks. If I click Rank Largest to Smallest I’ll see (Figure
8–18):
Figure 8–18. Assigning a ranking order to the salespersons by their sales
Cl i ck OK (thi s di al og box asks y ou whi ch fi e l d wi l l be subj e ct to thi s cal cul ati on , shoul d y ou be
working with more than one field). You’ll see (Figure 8–19):
Figure 8–19. Peacock rules the roost
Thus we see that Peacock tops the sales list. You could then actually sort the data horizontally so
that Peacock appears first and Leverling appears second, etc., by right-clicking anywhere in the
rankings (and not on the Salesperson names, though) and clicking Sort Sort Largest to Smallest
(Here “largest” is defined as 1—the higher ranking). Pretty cool, if you ask me; but I do go on. (Note: In
order to return to standard calculations such as sum and average, you need to click Show Values As
No Calculation .)
Moving and Removing Fields
Now time for a bit of important review. You’ll recall that when we launched our pivot report we
selected the report fields by clicking those check boxes alongside their names in the PivotTable Field
List. Needless to say, you can do the same with any field. But remember that where the field will wind
up on the report—in the Row or Column Labels areas, or in the Values area—is a decision Excel makes,
on the basis of where it seems most sensible to place the field. But if you want a field to populate the
Col umn Labe l s ar e a an d y ou cl i ck that fi e l d’ s che ck box, Exce l may de ci de to r e fe r i t to the Row Labe l s
area instead. Ultimately, however, you decide where the field goes, and you can always resituate it as
we’ve already seen, by clicking its button arrow and clicking on its new destination, or by clicking on
the button and dragging it to a different area. Alternatively, you can click on any field name in the
Pi v otT abl e Fi e l d Li st an d dr ag i t down into the desired button area, in the lower half of the list pane
(Figure 8–20):

Search JabSto ::

Custom Search