Calc Guide

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 category golfing are
subdivided according to another field.
Figure 222: 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 223: Selection of the field for the subdivision
Figure 224: After the drill down
230 OpenOffice.org 3.3 Calc Guide