Page 7 of 13PREVNEXT

PivotTable I: Get started with PivotTable reports in Excel 2007

Click Play to see how to add a field as a report filter.

Now you know how much each salesperson sold. But the source data lays out data about salespeople in two countries, Canada and the United States of America (USA). So another question you might ask is: What are the sales amounts for each salesperson by country?

To get the answer, you can add the Country field to the PivotTable report as a report filter. You use a report filter to focus on a subset of data in the report, often a product line, a time span, or a geographic region.

By using the Country field as a report filter, you can see a separate report for Canada or the USA, or you can see sales for both countries together.

To add this field as a report filter, right-click the Country field in the PivotTable Field List and then click Add to Report Filter. The new Country report filter is added to the top of the report. The arrow by the Country field shows (All), and you see the data for both countries. To see just the data for either Canada or the USA, click the arrow and select either country. To see the data for both countries again, click the arrow and then click (All).

Click Play to see how to add a field as a report filter.

Tip     To remove a field from a report, clear the check box beside the field name in the PivotTable Field List. To remove all the fields from the report so that you can start over, on the Ribbon, on the Options tab, in the Actions group, click the arrow on the Clear button, and then select Clear All.

Page 7 of 13PREVNEXT