Microsoft Office Tutorials and References
In Depth Information
Pivoting the Data Sideways Using the Column Labels Area
Figure 8–15. Just click Salesperson, and drag and drop it into the Row Labels area.
And you can do the same to Order Amount. Again, the reason you want to know about
this drag-and-drop technique is that it will let you move any database field to any of the
four areas. To remove a field from an area, just click the field, drag it into the worksheet
area (or back into the upper area of the PivotTable Field List), and release the mouse; the
field will disappear from the PivotTable (but not from the source data).
TIP: You can also remove a field from the PivotTable by unchecking the box alongside the field
you want to remove. Note that the box becomes checked whenever you place a field in an area,
regardless of whether you do so by ticking the box or dragging the field into the area.
Pivoting the Data Sideways Using the Column Labels Area
The Column Labels area does exactly the same thing as Row Labels, except that it breaks out
the data horizontally . Thus, this time if you drag Salesperson into the Column Labels area
instead, and leave Order Amount in the Values area, the PivotTable will look like Figure 8–16.
Figure 8–16. Change of direction: The sales data reading across, instead of down
Filtering Items Using the Report Filter Area
That takes us to the fourth PivotTable area: Report Filter. There’s a familiar word in there,
of course, and report filters work similarly to the filters you’ve already learned about, but
you need to understand what they do in a PivotTable.
Report filters give a different look to a PivotTable. As with the Row Labels and Column
Labels areas, the Report Filters area also breaks out the data in the Values area, but lets you
isolate the impact of one item in the field doing the breaking out. The following short
exercise will show you what that means.
Search JabSto ::

Custom Search