Calc Guide

More settings for the fields
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 preferences 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.
Figure 187: Expanded dialog for a data field
In the Displayed value section, you can choose more possibilities for
analysis by using the aggregate function. Depending on the setting for
Type, you have to choose a definition for Base field and Base
element.
248 OpenOffice.org 3.x Calc Guide