Datasheet

Figure 1-1: The sample data.
Creating a PivotTable Report
In this section I will guide you through the steps required to create a report that answers
the question posed above: What are the sales for the Camping category for each region?
To begin, you must start Excel and open the workbook that contains the raw data,
SportingGoodsRawData.xls. This workbook is provided for download from
wiley.com/go/excelpivottables/
Start by selecting PivotTable and PivotChart Wizard from the Data menu. Excel displays
the first step of the wizard, as shown in Figure 1-2.
Figure 1-2: The first step of the PivotTable and PivotChart Wizard.
Tip 3: Creating a PivotTable Report
Part I
5
03_772402 ch01.qxd 11/30/05 9:41 PM Page 5