Calc Guide

Choose the option Automatically to use the aggregate function for the partial
results that can also be used for the data fields (see above). To set up the aggregate
function for the partial results independently from the overall settings of the
DataPilot, choose User-defined.
Figure 207: Preferences dialog of a row or column field
Normally, the DataPilot does not show a row or column for categories that have no
entries in the underlying database. By choosing the Show items with no data
option, you can force this.
For illustration purposes, the data was manipulated in such a way, that the employee
Brigitte has no sales values for the category golfing.
Figure 208: Default setting
Chapter 8 Using the DataPilot 223