You can access many of these filter settings via the Advanced settings option in the above menu or the Advanced settings link below the Filters Section.
The advanced filter window appears as follows:
You can change a range of filter settings here.
Change the Operand (or argument) for that field: i.e. equal to, different from, in list, between (for dates), is null.
Change whether the filter is left as user prompt or a defined value - click the Define Value link and choose from the pop up window.
If your field is a date or time field, you can choose from a Defined Value (set date or date range) or a Pre‑defined Period (e.g. the last x months).
If you choose Dynamic Date, you can either choose a hard-coded date (turn the Dynamic Date slider off) or a date related to the date the report is run (e.g. Current Date – 12 months)
- Add additional filters.
- Access more advanced filter options, such as linking a filter to another filter or column, changing AND/OR arguments, and indenting filters.
