Microsoft Office Tutorials and References
In Depth Information
Using the Row and Column Value Areas to Group Items
Using the Row and Column Value Areas to Group Items
There’s still another approach to engineering a two-field breakout of the data. If you
click and drag on the Country bar and drop it into the Column Labels area, you get what’s
shown in Figure 8–30.
Figure 8–30. The fields, pivoted: Again, the data is exactly the same, but organized differently
We’ve orchestrated still another look to the data—kind of a matrix, in which the two
fields intersect in the Values area. Note the field positions in the Drag field between areas
below section—one in Row Labels, the other in Column Labels.
Changing the Calculation
By default, PivotTables will add, or sum, numerical fields in the Value area. But you may
want the table to calculate a different kind of result—say, an average or a maximum.
Changing to the kind of calculation you need is easy.
The following example will show you the amount of the average sale each salesperson
has made:
1. First, remove the Country field from the Column Labels area if you’ve
dragged it there. Remember, you can remove the field by clicking its bar
in the Drag field between areas below area and dragging into the worksheet;
release your mouse and the field will disappear. This will leave you with
your original, basic PivotTable result, in which sales are broken out by
TIP: You can also remove a field by clicking the bar itself and clicking Remove Field on the
menu that appears.
Search JabSto ::

Custom Search