IBM Lotus Symphony


Displaying source data

You can see the related source data displayed on a new sheet by double-clicking one of the cells in the DataPilot table.

To open the new sheet containing the related source data in the DataPilot table, perform the following steps:
  1. Select a DataPilot table.
  2. Right-click the DataPilot table, and select DataPilot Table Option.
  3. Select Enable drill to details and click OK.
  4. Double click one of the cell in different area, there are different output.
    1. Double click a cell in a row or column, and the subtotal for the same category is displayed. Other rows or columns are hidden in the DataPilot table.
    2. Double-click the cell in a data area and a new sheet is created before the current DataPilot table. This sheet contains the related source data. If you are using a filter in the DataPilot table, the detailed data in the new sheet does not include the data that is excluded by the filter rule.

Product Feedback | Additional Documentation | Trademarks