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

Figure 202: DataPilot result without Identify categories selected

Logically, the behavior without category recognition is better. A list with the

shown missing entries is also less useful, because you cannot use other functions

such as sorting or filtering.

Total columns / total rows

With this option you decide if the DataPilot will show an extra row with the sums

of each column or if it adds on the very right a column with the sums of each row.

In some cases, an added total sum is meaningless, for example if your entries are

accumulated or the result of comparisons.

Add filter

Use this option to add or hide the cell labelled Filter above the DataPilot results.

This cell is a convenient button for additional filtering options within the

DataPilot.

Enable drill to details

If you double-click on a single cell in the DataPilot result, this function gives a

more detailed listing of an individual entry. If this function is disabled, the double-

click will keep its usual edit function within a spreadsheet.

More settings for the fields – Field Options

The options discussed in the previous section are valid for the DataPilot in general.

Additionally, you can change settings for every field that you have added to the

DataPilot layout. Do this either by clicking on the Options button in the DataPilot

dialog or by double-clicking on the appropriate field.

There are differences between data fields, row or column fields, and page fields of

the DataPilot.

Data fields

In the Options dialog of a data field you can select the Sum function for accumulating

the values from your data source. In many cases you will need the sum function, but

other functions (like standard distribution or a counting function) are also available.

For example, the counting function can be useful for non-numerical data fields.

On the Data Field dialog, click More to see more options.

Chapter 8 Using the DataPilot 219

1 2 ... 214 215 216 217 218 219 220 221 222 223 224 ... 433 434

Sin comentarios

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