Page 6 of 10PREVNEXT

PivotTable II: Filter PivotTable report data in Excel 2007

Click Play to view an animation showing how to set a date filter.

Finally, suppose you want to see how well road bikes sold during a specific year, month, or other period of time. By setting a filter, you can tell the report what time period you are interested in, and temporarily hide data for all other periods.

To filter on a specific year is easy. To see the data for 2011 only, click the arrow next to Column Labels. You click there because dates are displayed in the column area of the report. In the list that appears, clear the check box next to (Select All) and then select the check box next to 2011. Excel hides the 2009 and 2010 figures. It's just that fast.

Next, say that you want to see how well road bikes sold during a particular month in 2011. To specify a time period for the date filter, click the arrow next to Column Labels. Point to Date Filters. Click Between. In the Date Filter dialog box, type 11/8/2011 in the first empty box. In the and box, type 12/8/2011. The report displays data for road bikes for the specified month only.

Click Play to view an animation showing how to apply a date filter.

Page 6 of 10PREVNEXT