Specifying filters

In the Columns and Filters dialog, the mandatory filter items are displayed. Which filters are required is determined by the DataLink through which links to the data source. To add additional filters, click the filter icon in the heading of the Filters pane. In the Add Filters pane, click filters to add them.

Some filters accept multiple values or ranges of values. Select the multi-selection operator to filter on multiple values or the range operator to filter on non-contiguous ranges.

To specify a filter:

Click the filter icon in the heading of the filter.
See: Specifying period filters.
To change the comparison operator, click the current operator and scroll to select the required operator.

Some filters accept multiple values or ranges of values. Select the multi-selection operator or the range operator.

Some operators provide options to specify case sensitivity and to use segments. Follow these steps to enable or disable the case sensitivity and segment options:
1. Click the Case Sensitive or Segment option on the selected operator.
2. Enable or disable the Case Sensitive option.
  Case sensitivity specifies whether upper and lower case values for a string are treated equally. For example, if Case Sensitive is selected, the strings 'ABC' and 'abc' are not equivalent.
3. Enable or disable the Use Segment option.
  For the Segment option type, click the Offset option and specify an offset.
Specify the value of the filter.
Specify the value manually or click the lookup icon and select.
Some filters accept multiple conditions. Click Add Condition and specify the filter.
Click Done when you have specified a filter.
When you have specified all filters, click Done to close the Columns and Filters dialog.
The Done button is disabled if any filter is incompletely specified.