en uk

Filtering a pivot table Microsoft Excel 2007

    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.

    Filtering a pivot
table Microsoft Excel 2007

    Figure 9-17:

    A filter lets you selec­tively 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.

    Filtering a pivot
table Microsoft Excel 2007

    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.

    Filtering a pivot
table Microsoft Excel 2007

    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.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.