Defining a value filter

You can define a value filter on the axis level.

  1. In the Ad-Hoc Report dialog box, select these options from the list:
    • Data connection
    • Cube
    • Columns
    • Rows
  2. Click the Filters tab on axis.
  3. Select Add > Value Filter.
  4. Specify this information:
    Condition
    Select one of these conditions:
    • Is empty
    • Is equal to
    • Is greater than
    • Is greater than or equal to
    • Is less than
    • Is less than or equal to
    • Is not empty
    • Is not equal to
    Value
    This field is a text field. Specify a string or numerical value.
    Note: Not all conditions apply to both strings and numerical values. For example, Is greater than does not apply to strings.
    Function

    The values of the opposite axis are considered in the filter calculation. If there are multiple columns or rows on the opposite axis, the axis's values are aggregated by the selected function and then evaluated against the selected filter criteria.

    Select one of these aggregation functions:

    • Any

      Compares all values of rows and columns with the filter criteria.

    • Average

      Divides the total of all values in rows and columns by the number of values. Compares the result with the filter criteria.

    • Maximum

      Evaluates all values of rows and columns. Compares the maximum value number with the filter criteria.

    • Minimum

      Evaluates all values of rows and columns. Compares the minimum value number with the filter criteria.

    • Sum

      Compares the total of all values in rows and columns with the filter criteria.

  5. Click Add.