Calc Guide

Type Base field Base element Analysis
% 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)
% of column — — Result as relative part
of the total column (for
example, the column
sum)
% of total — — Result as relative part
of the overall result
(for example the total
sum)
Index — — Default result x total
result / (row result x
column result)
Row and column fields
In the Options dialog for the row or column fields, you can choose to show partial
sums for each category. Partial sums are deactivated by default. They are only useful
if the values in one row or column field can be divided into partial sums for another
(sub)field.
Some examples are shown in the next three figures.
Figure 204: No subdivision with only one row or column field
Chapter 8 Using the DataPilot 221