Calc Guide

Figure 209: Setting “Show Items with no data”
Page fields
The Options dialog for page fields is the same as for row and column fields, even
though it appears to be useless to have the same settings as described for the row
and column fields. With the flexibility of the DataPilot you can switch the different
fields between pages, columns or rows. The fields keep the settings that you made for
them. The page field has the same properties as a row or column field. These settings
only take effect when you use the field not as page field but as row or column field.
Working with the results of the DataPilot
As mentioned above, the DataPilot is very flexible. An analysis can be totally
restructured with only a few mouse clicks. Some functions of the DataPilot can be
used only with the results of an analysis.
Start the dialog
Right-click in the area of the resulting table of the DataPilot. The command Start
opens the DataPilot dialog with all current settings.
Change layout by using drag and drop
The easiest and fastest method to change the layout of the DataPilot is drag and
drop. Within the result table of the DataPilot, move one of the page, column, or row
fields to a different position (see “Examples with step by step descriptions” starting
on page 194).
You can remove a column, row, or page field from the DataPilot by clicking on and
dragging it out of the DataPilot.
Grouping rows or columns
For many analyses or summaries, the categories have to be grouped. You can merge
the results in classes or periods. In the DataPilot you do a grouping only after you
have first made an ungrouped DataPilot table.
You can access the grouping with the menu entry Data > Group and Outline >
Group or by pressing F12. It is important that you select the correct cell area. How
the grouping function works is determined mainly by the type of values that have to
be grouped. You need to distinguish between scalar values, date or time values, or
other values, such as text, that you want grouped.
224 OpenOffice.org 3.3 Calc Guide