Simple Filter Data in Pivot Tables

By default, a Pivot Table processes all records when calculating its values. Data filtering allows you to process only those records that meet your requirements.

Simple Filtering
To filter against a field, do the following: · Hover over the field header. The filter button will be highlighted.

Click the filter button to display the filter dropdown list containing field values that can be filtered:

Deselect field values that must be hidden, and select fields that must be visible. Then, click OK to close the dropdown filter list and apply the filter.

In this manner, you can filter data against multiple fields.

To remove filtering against a specific field, invoke the field's filter dropdown list and select (Show All).

You can tell whether a field is being filtered by looking at its header. Filter buttons for these fields are visible even when you're not hovering over the field headers: