Calc Guide

For Sort by select how to display the information, either Ascending or
Descending. On the left side is a drop-down list where you can select
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.
Drilling (showing details)
Drill allows you to show the related detailed data for a single,
compressed value in the DataPilot result. To activate a drill, double-
click on the cell or choose Data > Group and Outline > Show
Details. You have to distinguish two cases:
1) The active cell is the category of a row or column field.
In this case drill means an additional breakdown into the
categories of another field.
For example, double-click on the cell with the value golfing in the
row field region. In this case the values that are aggregated in
the golfing category are subdivided according to another field.
Figure 205: Before the drill down for the category golfing
Since there are more possibilities for subdivision, a dialog
appears so you can choose your setting.
Figure 206: Selection of the field for the subdivision
Chapter 8 Using the DataPilot 259