The more information your pivot table contains, the harder it can be to make sense of any of the data. To help you out, Excel lets you filter your data to view only certain information, such as sales made by each salesperson or total sales within a region. To filter a pivot table, follow these steps:
1. Click the pivot table you want to filter.
The PivotTable Field List pane appears.
2. Click a heading in the Row Labels or Column Labels group in the PivotTable Field List pane.
A pop-up menu appears.
3. Click Move to Report Filter.
Excel moves your chosen label into the Report Filter group in the PivotTable Field List pane and displays a filter list box at the top of your pivot table, as shown in Figure 9-17.
A filter lets you selectively hide information in a pivot table.
4. Click in the filter list box at the top of the pivot table.
The list box displays a list of items that you can choose to view, as shown in Figure 9-18.
The filter list box lets you
Choose how to filter what you see in the pivot table.
5. Click an item to filter your data.
If you mark the Select Multiple Items check box, you can select two or more items to filter your data.
6. Click OK.
Excel displays your filtered pivot table, as shown in Figure 9-19.
A filtered pivot table displays only the information you want to see, such as showing you only sales results for the Southern sales region.