Clear the filter

To clear the report filter, follow the steps below:

1.Click the button in the row with the filter.

2.In the Filter window, select the Select all checkbox.

3.Click Apply.

To clear the filter for an individual row or column, follow these steps:

1.Click the / Sort and filter button in the row or column heading.

2.If you are using the Compact layout for a pivot table and you have added multiple fields to the row or column area, select the desired field from the drop-down list in the Row / Column field in the Sort and filter window.

3.Select the current filtering method (the Clear button will be clickable).

4.Click Clear.

To clear all filters applied in the table, follow the steps below:

1.Select one or more cells from the pivot table range.

2.On the Toolbar, in the Pivot table section, click  Clear filters in pivot table.