You can select the function and the display value that
you want to apply to the data area of a DataPilot table.
The function is determined by the data source, if the data
source is a number, then the field option is set to the Sum function
by default. If the data source is text or a date, the field option
is set to the Count function by default. The display value determines
the calculation type you want to use.
- Select a DataPilot table.
- Click the arrow on the field button or right-click the
field name in the data area on the DataPilot panel, and then select Field
Option.
- Click one of the tabs on Data Field Option and
select the appropriate option:
- Function – Select the function that
you want to apply to the data field.
- Display Value:
- Display the data value as: For each data
field, you can select the type of display. For some types you can
select additional information for a base field and a base item.
- Base field – Select the field from which
the respective value is taken as base for the calculation.
- Base item – Select the item of the base
field from which the respective value is taken as base for the calculation.
- Click OK.