You can customize the layout and structure of a DataPilot
table to show the data in the format that you want. You can also manipulate
the DataPilot table, such as resize, sort, filter the data and so
on.
Rearranging fields
You can rearrange fields to put them in different areas
or you can move fields to different position within one area.
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.
Setting DataPilot table properties
You can set properties of a DataPilot table to ignore empty
rows, identify categories, calculate grand totals, and keep table
formatting.
Sorting DataPilot tables
You can sort the DataPilot table in ascending, descending,
or a self-defined order.
Retrieving and refreshing the data
You can have the DataPilot table retrieve the new data
to display when the data source changes. If multiple DataPilot tables
share the same range of data source, then they are using the same
DataPilot cache. When one table is refreshed, the other tables are
refreshed at the same time
Using Variables in Equations
Using variables in equations, you can calculate
a value that, as part of a formula, leads to the result you specify
for the formula. You thus define the formula with several fixed values
and one variable value and the result of the formula.