Calc Guide

Figure 169: Absolute comparison with Brigitte
As a final example we switch to an accumulated view; that is,
continuing sums of all values:
1) Choose Data > DataPilot > Start.
2) Double-click on Sums – 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 twice.
Figure 170: The DataPilot now shows accumulated values
Differences and advantages
These examples show an important aspect of the DataPilot. Normally
you have to collect your data according to the way you want the result
to be represented. This means you have to use a specific structure and
you are stuck with it.
The DataPilot works more like a real database. The source data is
collected in a simple spreadsheet that contains all data. Only when you
want to look at it do you select which part of the data you want to use.
Chapter 8 Using the DataPilot 233