• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Working with Pivot Tables > Filtering a Pivot Table

Filtering a Pivot Table

You can exert even more control over the display in your pivot table by choosing which of a field's values to display. For instance, you can choose to display only books published during a particular calendar year, you can look at sales from a particular quarter over several years, or you can just view sales from specific sales reps.

To filter a pivot table:

1.
Open the pivot table you want to filter and click the Edit Pivot Table button at the bottom of the window.

2.
Click the drop-down menu on the field header to display the values in that field. By default, they are all selected to be displayed in your results (Figure 11.20).

Figure 11.20. Click the drop-down menu on a field's header to display a list of the values in that field.


3.
Clear the checkbox next to the values you don't want displayed in your results (Figure 11.21).

Figure 11.21. Every selected value is displayed in your pivot table; to hide information, clear its checkbox.


4.
Click OK.

Excel redraws your pivot table using only the values you selected in the drop-down menu (Figure 11.22).

Figure 11.22. Click OK to present your pivot table in filtered form.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint