Calc Guide

The result is much more powerful than is possible with the classic
formula-based calculation. For example, you can summarize the daily
results to a monthly result very easily:
1) To group together the rows, select the cell A5 (or any other cell
that contains a date).
2) Choose Data > Group and Outline > Group and click OK. The
result is now grouped into months.
Figure 166: Monthly sums
If you need a result with a percentage, start the DataPilot from this
page.
1) Select the cell A3 (or any other single 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
(Figure 167).
4) Click on More, to see more options.
5) Switch Displayed value > Type to % of column.
6) Click OK twice.
The result shows percentages as a decimal number. If you prefer to
have a percent format, select the cells and click on the % icon in the
menu bar.
Chapter 8 Using the DataPilot 231