Calc Guide

Figure 168: DataPilot result without grouping
8) To group the columns, select cell B4 or any other cell that contains a date.
Then select Data > Group and Outline > Group. On the Grouping dialog
(Figure 169), make sure Intervals and Months are selected in the Group by
section, and click OK. The result is now grouped for months (Figure 170).
Figure 169: Grouping on months
Figure 170: 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.
Chapter 8 Using the DataPilot 197