Calc Guide

Tip

For grouping the DataPilot in calendar weeks, define the

beginning as a Sunday or Monday and manually enter the

grouping interval of 7 days.

Grouping without the automatic creation of intervals

If the categories contain text fields, then the automatic creation of

intervals isn't possible. You can define for each category of any data

type which categories you want to put together in one group.

Every time you use the menu entry Data > Group and Outline >

Group or you press F12 and you have more than one cell selected,

then all the cells will be selected as one group.

Figure 198: Database with

nonscalar categories (departments)

Figure 199:

DataPilot with

nonscalar