Calc Guide

You could, for example, list all the sales values per day and additionally give the
number of entries per day. To do this, put both the sales field and the date field into
the Data Fields area. For the date field, choose the Count option for the aggregate
function (see Figure 228).
Since every entry has a specific date, this field will give you the number of entries for
each date. If you group the values per month, you get an overview with the sales
value and the number of closed sales for each category and month (see Figure 229).
Figure 228: Multiple data fields in the DataPilot
Figure 229: DataPilot shows sales value and number of entries
Chapter 8 Using the DataPilot 233