Calc Guide

Note
Before you can group, you have to produce a DataPilot with
ungrouped data. The time needed for creating a DataPilot
depends mostly on the number of columns and rows and not on
the size of the basic data. Through grouping you can produce the
DataPilot with a small number of rows and columns. The
DataPilot can contain a lot of categories, depending on your data
source. Computing time may take several minutes.
Grouping of categories with scalar values
For grouping scalar values, select a single cell in the row or column of
the category to be grouped.
Figure 194: DataPilot
without grouping (frequency
of the km/h values of a radar
control)
Figure 195: DataPilot
with grouping (classes
of 10 km/h each)
Choose Data > Group and Outline > Group from the menu bar or
press F12; you get the following dialog.
Figure 196: Grouping dialog with scalar categories
254 OpenOffice.org 3.x Calc Guide