Filtering by Comparing Data Values

  To filter data by restricting the data returned:

  1. To display the data filter panel, in the navigation panel, select Data Filtering.

  2. Double-click in Data Restrictions.

    Data restrictions apply standard data comparison operations (such as greater than, less than, and equal to) to data values.

    If you define multiple criteria for a column, you can use the OR and AND operators to link the criteria.

  3. From Data values, select a value.

  4. Select one option:

    • a value of enables you to compare the data to a data value, including a negative data value.

    • the data values in enables you to compare data from other column dimensions.

    • a #MISSING value enables you to compare data to #MISSING data value.

  5. From Column used for filter, select a column dimension member combination.

    The member combinations listed here are determined by the members that you selected for the column dimensions. The data values for the specified column dimension members are used to compare data.

  6. Optional: If you want to apply multiple data filters, repeat step 2 through step 5, and select And or Or.

    The And option specifies that data must meet all criteria. The Or option specifies that the data must meet at least one of the criteria.

Next, you can sort the data, or apply the query now.

Related Topics

Applying Queries

Applying Multiple Data Filters

Filtering by Ranking Data Values

Creating Data Sorts