Use the value selection dialog box evoked by the Select Filter Value context menu item to configure complex filter conditions. Filtering lets you define a set of criteria that restricts the set of records returned as the result of a query. With filters, you define which subset of data appears in the query result, allowing you to create new, more specific views of your data. You can select filter values while in analysis mode in the analysis grid or navigation pane.
The filter value selection dialog box lists all the values that belong to the dimension or structure member (key figure) of the currently selected cell, which allows you to select single or multiple contiguous or disparate values.
For example, you want to see how sales are doing in your South and East regions. To do so, you scroll in the analysis grid or navigation pane to a cell containing either the Region dimension or one of the regions itself. From the context menu, you choose Select Filter Value, and the value selection dialog box appears. In it, all the regions in the Region dimension are listed:
You select South and East from the list, and confirm your selection. In the workbook, the analysis grid updates to show only the data for the South and East regions.
You can also evoke the filter value selection dialog box using the filter icons in the navigation pane.
You have filtered your query by your selection. The analysis grid updates to reflect the results of the query with the new filter. In the navigation pane, if present, the third column (filter area) updates with the currently configured values of the corresponding dimension or structure member (key figure).
To remove a filter, scroll to where you have configured the filter and from the context menu, choose Remove Filter. You can also use the remove filter icons in the navigation pane.