Filter rows and columns by condition

Two filtering options are available for filtering by condition: by caption (column/row name) and by the values of the calculated data contained in the value area of the pivot table.

To filter a row or column by caption condition, 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.Select the By condition filtering method.

4.In the Show box, select the Captions option from the drop-down list.

5.In the Condition box, select the type of condition from the drop-down list and in the adjacent box, input the text value for which the condition should be met. In the current version of MyOffice Spreadsheet, regular expressions (“*”, “?” operators) are not supported when inputting a text value.

6.Click Apply.

To filter a row or column by condition for the calculated data values, follow these steps:

1.Click the filter button in the row/column title.

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 By condition filtering method.

4.In the Show box, select the Values option from the drop-down list.

5.If more than one field has been added to the value area in the pivot table, select the desired field from the Field drop-down list.

6.In the Condition box, select the type of condition from the drop-down list and in the adjacent box, input the numeric value for which the condition should apply.

7.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.