Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
When you click the filter arrow of a field in the Filters area, Excel displays a list of the values
in the field. When you click the filter arrow, you can choose to filter by one value at a time.
If you’d like to filter your PivotTable by more than one value, you can do so by selecting the
Select Multiple Items check box.
If your PivotTable has more than one field in the Rows area, you can filter values in a
PivotTable by hiding and collapsing levels of detail within the report. To do that, you click
the Hide Detail control (which looks like a box with a minus sign in it) or the Show Detail
control (which looks like a box with a plus sign in it) next to a header.
For example, you might have your data divided by year; clicking the Show Detail control
next to the 2012 year header would display that year’s details. Conversely, clicking the 2013
year header’s Hide Detail control would hide the individual months’ values and display only
the year’s total.
Excel 2013 also lets you filter PivotTables using search filters. With a search filter, you can
enter in a series of characters for Excel to filter that field’s values. To create a search filter,
click a field’s filter arrow and enter the character string that you want to search for in the
filter menu’s Search box.