You can allow the user who executes the report that contains the filter, to decide for himself certain aspects of the filter's definition. This lets each individual user define the report results he sees. To do this, you include a prompt in the filter's definition. You can use prompts in any filter where you want to let each user impact the results of the filter, by having the user enter a specific number, date, or text that makes sense for that user. To add a prompt to your filter's definition, use the following high-level steps:
Decide what prompt type you need for your filter. Prompt types that you can use in a filter's definition are listed in the table in About prompts.
Follow the steps in one of the prompts topics to create that prompt:
Filtering data on an attribute form: Attribute element list prompts
Filtering data on attributes from a hierarchy: Hierarchical Qualification prompts
Filtering data on an attribute: Attribute qualification prompts
Filtering data based on metrics, attributes, or other objects: Object prompts
Then follow the steps in one of the filter topics to add the prompt to your filter's definition:
Filtering data based on attribute forms: Attribute form qualification
Filtering data based on attribute elements: Attribute element list qualification
Filtering data based on metric values or rank: Set qualification
Filtering data based on report results: Shortcut-to-a-report qualification
Filtering data based on an existing filter: Shortcut-to-a-filter qualification