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.
- Click .
- 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.