Formatting and Organizing the
Next we will examine ways we can organize the
new PivotTable view to make it easy to use. We will format and organize our
view, then briefly examine filtering, sorting and grouping.
the new Sum of Net Sale calculated total in the PivotTable view to
the Properties button (shown in Illustration 26) on the
Illustration 26: The Properties Button on the PivotTable
The Properties dialog appears for the Sum of Net
Sale calculated total field.
the Captions tab.
Total Net Sale in the Caption text box.
The Properties dialog, Captions tab for the Total
Net Sale calculated total appears as shown in Illustration 27.
Illustration 27: The Properties Dialog, Captions Tab, for the
Total Net Sale Field
the Properties dialog open, click the label for the new Count of Net
Sale calculated total field on the PivotTable.
The Properties dialog switches to display the
settings for the Count of Net Sale column.
No. Line Items in the Caption text box.
The Properties dialog, Captions tab for the No.
Line Items calculated total appears as shown in Illustration 28.
Illustration 28: The Properties Dialog, Captions Tab for
the No. Line Items Field
the Properties dialog.