Calc Guide

Figure 203: Expanded dialog for a data field
In the Displayed value section, you can choose other possibilities for analysis by using
the aggregate function. Depending on the setting for Type, you may have to choose
definitions for Base field and Base element. The table below lists the possible types
of displayed value and associated base field and element, together with a note on
usage.
Type Base field Base element Analysis
Normal — — Simple use of the
chosen aggregate
function (for example,
sum)
Difference
from
Selection of a field
from the data
source of the
DataPilot (for
example, employee)
Selection of an
element from the
selected base field
(for example,
Brigitte)
Result as difference to
the result of the base
element (for example,
Sales volume of the
employees as
difference of the sales
volume of Brigitte)
% of Selection of a field
from the data
source of the
DataPilot (for
example, employee)
Selection of an
element from the
selected base field
(for example,
Brigitte)
Result as a ratio based
on the result of the
base element (for
example, Sales result
of the employee
relative to the sales
result of Brigitte)
220 OpenOffice.org 3.3 Calc Guide