Calc Guide

Figure 207: After the drill down
To hide the details again, double-click on the cell containing
golfing or choose Data > Group and Outline > Hide Details.
The DataPilot remembers your selection (in our example the
employee field), so that for the next drill down for a category in
the region field, the dialog does not appear. To remove the
employee selection, open the DataPilot dialog by right-clicking
and choosing Start, then delete the unwanted selection in the
row or column field.
2) The active cell is a value of the data field.
In this case drilldown means a listing of all data entries of the
data source that aggregates to this value.
Double-click on the cell with the value $18,741 from Figure 205.
You now have a new list of all data sets that are included in this
value. This list is shown in a new sheet.
Figure 208: New table sheet after the drilldown
for a value in a data field.
Filtering
To limit the DataPilot analysis to a subset of the information that is
contained in the data basis, you can filter with the DataPilot.
260 OpenOffice.org 3.x Calc Guide