IBM Lotus Symphony


Using the field option

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.

  1. Select a DataPilot table.
  2. 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 Field Optionto open the Field Option dialog box.
  3. Optional: Put the cursor in the DataPilot table, right-click Page, Column, or Row, and select Field Option.
  4. 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.
  5. 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.
  6. 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.
  7. Click OK.

Product Feedback | Additional Documentation | Trademarks