PivotTable Fundamentals - Microsoft Business Intelligence Tools for Excel Analysts - page 18

3. Specify the location of your source data.

4. Specify the worksheet where you want to put the PivotTable.

The default location for the new PivotTable is New Worksheet. This means your PivotTable is
placed in a new worksheet within the current workbook. If you want to add your PivotTable
to an existing worksheet, select Existing Worksheet and specify the worksheet in which you
want to place the PivotTable.

5. Click OK.

At this point, you have an empty PivotTable report on a new worksheet, with the PivotTable
Field pane next to it, as shown in Figure 2-3. You find out how to populate your PivotTable
using this pane in the next section.

Figure 2-3: The PivotTable Fields List pane.

Laying out the PivotTable
You can add fields to the PivotTable by dragging and dropping the field names to one of the four
areas found in the PivotTable Fields list — Filters, Columns, Rows, and Values.

If you don't see the PivotTable Fields List pane, right-click anywhere inside the
PivotTable and select Show Field List. Alternatively, with your PivotTable selected, click
the Field List icon in the Show group on the Options tab of the Ribbon.

Tip