Filtering Pivot Tables

You can use filters to remove unwanted data from a pivot table.

Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the Filter command. The Filter dialog appears. Here you can filter the pivot table.

You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field.

Open file with example: