You can sort the DataPilot table in ascending, descending,
or a self-defined order.
To sort the data in the DataPilot table, complete the following
steps.
- Click the arrow on the field button in a page, row, or
column area on the DataPilot panel.
- On the menu, select Field Option.
- In the Field Option window, click
the Sort tab.
- Select Ascending, Descending,
or Manually.
- Select one of the fields in Using field,
and click OK.
- If you selected to manually sort, drag the field and the
position that you want or cut and paste to organize the order.
- Optional: Click
in the DataPilot panel to sort the DataPilot
table in ascending order; click
to sort in descending order.