OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 231)

100

101

To hide the details again, double-click on the cell golfing or choose Data >

Group and Outline > Hide Details.

The DataPilot remembers your selection (in our example the field employee),

so that for the next drill down for a category in the field region the dialog does

not appear. To remove the selection employee, 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 drill down 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 222. 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 225: 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.

Note

An Autofilter or default filter used on the sheet has no effect on the

DataPilot analysis process. The DataPilot always uses the complete list

that was selected when it was started.

To do this, click Filter on the top left side above the results.

Figure 226: Filter field in the upper left area of the DataPilot

In the Filter dialog, you can define up to 3 filter options that are used in the same

way as Calc’s default filter.

Chapter 8 Using the DataPilot 231

1 2 ... 226 227 228 229 230 231 232 233 234 235 236 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 231

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3