Calc Guide

Figure 153: Grouping on months
Figure 154: DataPilot result grouped for months
In this result you will recognize the beginners’ example. It is very easy
to produce, without any further knowledge about the spreadsheet. You
do not have to enter any formulas.
Advantages
1) No manual entering or adding of any values is necessary. There is
less work and fewer errors.
2) The layout is very flexible: months are listed horizontally and
fields vertically or vice versa, in two mouse clicks.
3) Additional differentiating factors are immediately available.
4) Many types of evaluation are possible; for example, number or
average instead of sum, accumulated values, comparisons, and so
on.
Chapter 8 Using the DataPilot 223