Specify Values for Filters

You can specify the values for a filter that displays in an analysis only those values in which you’re interested.

For example, in the Brand Revenue analysis, a filter can limit the analysis results to only the first quarter values in three years. As a result, you can discover how revenue performed year-to-year in these quarters.

  1. In the New Filter dialog, select the appropriate operator such as is equal to / is in.
  2. Select values from the list or click the Search icon to find more values from which to select.
  3. Optional: Select Protect Filter to prevent prompts from overwriting the filter.
  4. Optional: Select Convert this Filter to SQL.
  5. Click OK.
After specifying values, save the filter as named or inline.