Microsoft Office Tutorials and References
In Depth Information
To filter a PivotTable based on a field’s contents, click the field’s header in the Choose
Fields To Add To Report area of the PivotTable Field List task pane. When you do, Excel
displays a menu of sorting and filtering options.
The PivotTable displays several sorting options, commands for different categories of
filters, and a list of items that appear in the field you want to filter. Every list item has a
check box next to it. Items with a check mark in the box are currently displayed in the
PivotTable, and items without a check mark are hidden.
The first entry at the top of the item list is the Select All check box. The Select All check
box can have one of three states: displaying a check mark, displaying a black square,
or empty. If the Select All check box contains a check mark, then the PivotTable
displays every item in the list. If the Select All check box is empty, then no filter items are
selected. Finally, if the Select All check box contains a black square, it means that some,
but not all, of the items in the list are displayed. Selecting only the Northwest check box,
for example, leads to a PivotTable configuration in which only the data for the Northwest
center is displayed.