Calc Guide

set up the aggregate function for the partial results independently
from the overall settings of the DataPilot, select User-defined.
Figure 191: 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 golfing category.
Figure 192: Default setting
Figure 193: Setting “Show Items with no data”
252 OpenOffice.org 3.x Calc Guide