Calc Guide

Figure 180: Part of DataPilot dialog
The result appears on a new sheet (Figure 181).
Figure 181: The evaluation, done within seconds with DataPilot
The result is much more powerful than is possible with the classic formula-based
calculation. For example, you can summarize the daily results to a monthly result
very easily:
1) To group together the rows, select the cell A5 (or any other cell that contains a
date).
204 OpenOffice.org 3.3 Calc Guide