Calc Guide

Figure 182: DataPilot dialog
Row Fields and Column Fields indicate in which groups the result will
be sorted in the rows and columns. If there are no entries in one of
these area, then partial sums will not be provided for the
corresponding rows or columns. Often more than one field is used at
the same time get partial sums for rows or columns. The order of the
fields gives the order of the sums from overall to specific.
For example, if you drag region and employee into the Row Fields
area, the sum will be divided into the employees. Within the employees
will be the listing for the different regions.
Fields that are placed into the Page Fields area appear in the result
above as a drop down list. The summary in your result takes only that
part of your base data into account that you’ve selected. For example,
if you use employee as a page field, you can filter the result shown for
each employee.
To remove a field from the white layout area just drag it to the border
and drop it (the cursor will change to a crossed symbol), or click the
Remove button.
More options
To expand the DataPilot and show more options, click More.
Chapter 8 Using the DataPilot 245