Calc Guide

Figure 159: Additional subdivision into regions, added later
In another variation you may want to add the employees.
1) Select the cell A3 (or any other single cell that is part of the
DataPilot result).
2) Select Data > DataPilot > Start, to start the DataPilot again.
• You do not need the Region field in this case. Drag it out of
the layout area.
• Drag the Employee field into the Page Fields area.
3) Click OK. The result is shown in Figure 160.
Fields that you use as page fields are placed in the result above the
summary with the name Filter. You then have a drop-down list that you
can use to show only the sums of a given employee.
Up to now we have not seen the most powerful features of the
DataPilot. The following examples will show you more.
226 OpenOffice.org 3.x Calc Guide