You can set the field display name, calculate subtotals,
and sort the values of page, column, or row areas in a DataPilot table
by setting the field option. The current field name is displayed in
the title of the window.
- Select a DataPilot table.
- In the DataPilot panel, click the
arrow on the field button in one of the areas: Page, Column and Row.
Select Field Option, and then the Field
Option window displays. You can also click
to open the Field Option dialog box.
- Optional: Put the cursor in the DataPilot table,
right-click Page, Column,
or Row, and select Field Option.
- Click Field tab and specify the
field display name in the Display name field.
The display name is shown on the DataPilot table and areas in the
DataPilot panel. Select Show items without data if
you want the DataPilot table to include the empty columns and rows
in the result table.
Note: The display name cannot be duplicated.
If you enter the display name which already exists, a message box
opens and you must enter a new name.
- Click Subtotals tab and select the
appropriate subtotals option:
- Never – Does not calculate subtotals.
- Automatically – Automatically calculates
subtotals.
- Manually – Select this option, and
then specify the functions to calculate in the list.
- Using Function – Click the functions
to calculate subtotals. This option is only available when the Manually option
is selected.
- Click Sort tab and select the appropriate
sort option:
- Manually (Select items in the table and drag to
organize them) – Sorts items manually by letting you drag
them in the table. Use Ctrl+Click to select a single item to drag.
- Ascending – Automatically sorts the
values from the lowest value to the highest value.
- Descending – Automatically sorts the
values from the highest value to the lowest value.
- Using Field – Select the field to sort.
- Click OK.