Page 2 of 10PREVNEXT

PivotTable II: Filter PivotTable report data in Excel 2007

Excel 2007 PivotTable report before filtering

PivotTable report before filtering.

Imagine that you have opened a PivotTable report for products sold by Adventure Works, a sporting goods company.

The report nicely summarizes more than 6,000 rows of Excel worksheet data, showing you what all that data means. You can see, for example, the yearly sales totals for each product over a three-year period, and there is also a grand total of sales for each product.

Now you want to look at specific details. Adventure Works sells products ranging from water bottles to road bikes and vests. You'd like to see the sales amounts for road bikes only. Then you'd like to see which road bikes sold the most. And then you want to see how selected road bikes sold during a certain period of time.

You can see exactly what you want by filtering the PivotTable report data.

Page 2 of 10PREVNEXT