Calc Guide

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)
% 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 relative
difference to the
result of the base
element (for
example, Sales
volume of the
employees as
relative difference of
the sales volume of
Brigitte)
Running
total in
Selection of a
field from the
data source of
the DataPilot
(for example,
date)
— Result as a
continuing sum (for
example, Continuing
sum of the sales
volume for days or
months)
% of row — — Result as relative
part of the result in
the whole row (for
example the row
sum)
Chapter 8 Using the DataPilot 249