IBM Lotus Symphony


Organizing data using a DataPilot table

A DataPilot table provides a summary of large amounts of data. You can then rearrange the DataPilot table to view different summaries of the data.

  1. Click Data > DataPilot.
  2. On the DataPilot menu, click one of the following options:
    • Create – Opens a window where you can select the source for your DataPilot table, and then create your table.
    • Data Source Filter – Opens the Filter window.
    • DataPilot Table Option:
      • Ignore empty rows: Ignores empty fields in the data source.
      • Identify categories: Automatically assigns an empty row with the values from the preceding row.
      • Total columns: Calculates and displays the grand total of the column calculation.
      • Total rows: Calculates and displays the grand total of the row calculation.
      • Enable show details – Double click cells of row or column in DataPilot table, some data can be displayed or hidden with this option enabled. Double click cells of data area in DataPilot table, a new sheet which contains the related source data is created with this option enabled.
      • Automatically resize column width – DataPilot table column width is auto-resized to fit the width of the contents when data changed in the DataPilot table with this option enabled.
      • Preserve formatting – Preserves formatting for Field and Data areas with this option enabled.
    • Refresh Data – Refreshes the DataPilot table. This option is especially useful when you import a spreadsheet that contains a DataPilot table.
    • Delete DataPilot Table – Deletes the selected DataPilot table.
    • Show DataPilot Panel – Displays the DataPilot window.

Product Feedback | Additional Documentation | Trademarks