You can define the DataPilot table structure to display
and analyze the data in a format that you want.
To define the DataPilot structure, complete the following
steps:
To assign the fields to different areas, do one of the
following:
You can drag and drop the fields to page, row, column
or data area to define the DataPilot table structure.
Click the arrow on the field button on the DataPilot
panel and then select the appropriate item: Add to Page, Add
to Column, Add to Rows or Add
to Data by to place the field in a specific area.
Note: If you use drag and drop to assign fields to the data
area, the function is set to a default type. If you click Add
to Data by to assign fields, you need specify the functions
on the sub menu.
To remove the fields from an area, there are multiple ways
to do it, such as:
Click the arrow on the field button on the
DataPilot panel and select Remove from Areas.