Filter rows and columns by values

To filter a row or column by values, 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 the pivot table and have added multiple fields to the row or column area, in the Sort and filter window, in the Row / Column drop-down list, select the required field.

3.Make sure that By value filtering option is selected and clear the Select all checkbox.

4.Select the checkboxes next to the values you want to display.

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

•Enter the value you want to find (in full or partially). For example, to find the number 123, you can enter the numbers 12, 23 or 123 in 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.

6.Click Apply.

Once the filter has been applied, the / sort and filter button in the cell with the row or column header will look like / . When you move the cursor over the button, a tooltip with information about enabled filters and sorting settings will be displayed.