Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
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.
If you’d rather display as much PivotTable data as possible, you can hide the PivotTable
Fields pane and filter the PivotTable by using the filter arrows on the Rows and Columns
headers within the body of the PivotTable. When you click either of those headers, you can
select a field by which you can filter; you can then define the filter by using the same
controls that are available when you click a field header in the PivotTable Fields pane.
10
Excel indicates that a PivotTable has filters applied by placing a filter indicator next to the
Columns or Rows header, as appropriate, and the filtered field name in the PivotTable
Fields pane.
So far in this example, all the fields by which the PivotTable has been filtered has changed
the organization of the data in the PivotTable. Adding some fields to a PivotTable, however,
might create unwanted complexity. For example, you might want to filter a PivotTable by
weekday, but adding the Weekday field to the body of the PivotTable expands the table
unnecessarily.
 
Search JabSto ::




Custom Search