Calc Guide

Figure 177: properties for grouping according to hours
10) Figure 178 shows the Data Field dialog for the data field Number
– Date. Click More and select as type % of column. The result is
shown in Figure 180. Figure 179 shows the absolute occurrence.
Whether the relative values are shown as a decimal (0.1) or as a
percentage (10%) depends only on the cell formatting itself and
has nothing to do with the DataPilot.
Figure 178: Data Field settings for relative values
Chapter 8 Using the DataPilot 239