Calc Guide

Figure 150: Basic data in Calc
You can create the sales volume overview by following these
instructions:
1) Select the cell A1 (or any other single cell within the list).
2) Select Data > DataPilot > Start. On the Select Source dialog,
select Current selection and click OK.
3) The DataPilot dialog (Figure 151) has four white layout areas and
several fields that look like buttons. These small fields are the
titles of the different columns of your list.
• Move the date field into the Column Fields area.
• Move the sales field into the Data Fields area.
• Move the category field into the Row Fields area.
4) Click More, to see more options in the lower part of the dialog.
5) In the Results to field, select – new sheet – from the drop-down
list.
Chapter 8 Using the DataPilot 221