Sort manually by using drag and drop
You can change the order within the categories by moving the cells with the category
values in the result table of the DataPilot.
Be aware that in Calc a cell must be selected. It is not enough that this cell contains
the cell cursor. The background of a selected cell is marked with a different color. To
achieve this, click in one cell with no extra key pressed and redo this by pressing also
the Shift or Ctrl key. Another possibility is to keep the mouse button pressed on the
cell you want to select, move the mouse to a neighbor cell and move back to your
original cell before you release the mouse button.
Sort automatically
To sort automatically, start the options of the preferences of the row or column field:
right-click on the table area with the DataPilot result and choose Start to open the
DataPilot (Figure 167). Within the Layout area of the DataPilot, double-click the field
you want to sort. In the Data Field dialog (Figure 197), click Options to display the
Data Field Options dialog (Figure 221).
For Sort by choose either Ascending or Descending. On the left side is a drop-down
list where you can choose the field this setting should apply to. With this method you
can specify that sorting does not happen according to the categories but according to
the results of the data field.
Chapter 8 Using the DataPilot 229
Comentarios a estos manuales