Calc Guide

Type Base field Base element Analysis
% 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 preferences dialog for the row or column fields, you can display
the 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 188: No subdivision with only one row or column field
250 OpenOffice.org 3.x Calc Guide