Calc Guide

Figure 184: Result with percentages
To get a comparison between employees, start the DataPilot again from the output
sheet:
1) Select the cell A3 (or any other cell that contains a result of the DataPilot).
2) Choose Data > DataPilot > Start.
3) Double-click on Sum – hours to open the Data Field dialog.
4) Click More, to see more options.
• Switch the Type of the displayed value to Difference from.
• Switch the Base field to name.
• Switch the Base item to Brigitte.
5) Click OK to return to the DataPilot dialog, then click OK again.
Figure 185: Absolute comparison with Brigitte
As a final example we switch to an accumulated view; that is, continuing sums of all
values:
1) Select the cell A3 (or any other cell that contains a result of the DataPilot).
1) Choose Data > DataPilot > Start.
2) Double-click on Sum – hours to open the Data Field dialog.
3) Click More, to see more options.
• Switch the type of the displayed value to Running total in.
• Switch the Base field to Date.
4) Click OK to return to the DataPilot dialog, then click OK again.
206 OpenOffice.org 3.3 Calc Guide