Microsoft Office Tutorials and References
In Depth Information
USING THE PIVOTTABLE FIELD LIST TOOLBAR TO LAY OUT A PIVOT TABLE
When you drag a field button to the Data area, the PivotTable and PivotChart
Wizard applies the Sum function if the field contains numeric values; it applies the
Count function if the field contains non-numeric values.
While you set up the pivot table, you can double-click a field button to
customize it. You can specify, for example, to summarize a particular field as a Count
or other function. You also can specify which items in a field to hide or omit. If you
drag a field button to an incorrect location, just drag it off the table diagram to get
rid of it. Note that you can customize fields at any time after you create the pivot
table; I demonstrate this later in the chapter.
Figure 9-9 shows how the dialog box looks after dragging some field buttons to
the pivot table diagram. This pivot table displays the sum of the Amount field,
broken down by AcctType (as rows) and Customer (as columns). In addition, the
Branch field appears as a page field. Click OK to redisplay the PivotTable and
PivotChart Wizard — Step 3 of the dialog box.
Figure 9-9: The table layout after dragging field
buttons to the pivot table diagram
USING THE PIVOTTABLE FIELD LIST TOOLBAR
TO LAY OUT A PIVOT TABLE
You may prefer to lay out your pivot table directly in the worksheet, using the
PivotTable Field List toolbar. The technique closely resembles the one just
described, because you still drag and drop fields. But in this case, you drag fields
from the toolbar into the worksheet.
You cannot use this technique with versions prior to Excel 2000. Also, note
that Excel 2000 doesn’t have a PivotTable Field List toolbar. Rather, the fields
are displayed as buttons on the PivotTable toolbar.