IBM Lotus Symphony


Selecting the function and the display value

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.
  1. Select a DataPilot table.
  2. 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.
  3. 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.
  4. Click OK.

Product Feedback | Additional Documentation | Trademarks