You can rearrange fields to put them in different areas
or you can move fields to different position within one area.
To arrange the fields, do one of the following tasks:- Assign fields to different areas by clicking the arrow on
the field button in one of the areas on the DataPilot panel, and then
selecting one of the following options:
- Move to Page – Moves the field to a page
area.
- Move to Column – Moves the field to a column
area.
- Move to row – Moves the field to a row
area.
- Move to Data by – Moves the field to the
data area and selects the appropriate formula that is used to calculate
the data.
- Move the fields within one area by clicking the arrow on the
field button in one of the areas on the DataPilot panel, and then
selecting one of the following options:
- Move up – Moves the field up one position
in the area.
- Move down – Moves the field down position
in the area.
Note: Drag and drop the field is a simple way to arrange
the fields too.