Filter data using the report filter

To filter the pivot table data using the report filter, follow these steps:

1.Add the fields that you want to use for filtering to the Filters area in the Constructor of the pivot table.

2.Click the filter button in the row with the desired field at the top of the table.

3.Select the checkboxes next to the values you want to include in the generation of the pivot table.

4.If the list contains a large number of values, use the search bar:

•In the search results, select the checkboxes next to the values you want to display in the column.

•If necessary, repeat the steps to find and select other values.

5.Click Apply.

After applying the filter, the button in the row with the filter will look like .