Datasheet

Figure 1-6: The completed PivotTable report.

I hope that you are suitably impressed with how easy it was to create this PivotTable

report. Yes, it’s a simple one, but the same principles apply for more complex requirements.

At this time I want to point out a couple of other aspects of PivotTable reports.

When the report is active, the PivotTable Field List is displayed. Fields that are part of the

report are displayed in boldface in this list. To make the PivotTable active, click anywhere

in it. To make it inactive, click somewhere else in the worksheet.

Note that the Region heading in the report has a drop-down arrow next to it. If you click

this arrow Excel displays a list of all the row values as shown in Figure 1-7 — in this case,

the names of the three regions, Midwest, Northeast, and South. By checking or unchecking

individual items in this list, including the Show All option, you can change what the

PivotTable displays.

Figure 1-7: Selecting which rows to display in the PivotTable report.

For example, by selecting only the Midwest item and then clicking OK, you modify the

report to show Camping category sales for the Midwest region only, as shown in Figure 1-8.

Figure 1-8: The PivotTable report customized to display only the Midwest region.

If you have changed the report to display only a single region, change it back to Show All

for the next step.

Part I: Understanding PivotTables and Charts

03_772402 ch01.qxd 11/30/05 9:41 PM Page 8