...
There are three types of filters available in the Filters window:
Standard Filters
Standard filters limit data by only showing rows where the values for a field meet a certain condition.
...
If you want to let users select their own filter values when they run the report, you can set filters to Prompt For Value. In the Report Options, you can choose whether to let users change the operators and delete filters.
...
Once the formula is created as a column, select the Filters pane and drag the formula column over to the Filters pane to begin creating a filter on the formula. For more information about building formulas in an ExpressView, see the Support Site article on Formulas in ExpressViews.
Note: Certain function are available in the Formula Editor that are not compatible with the context of formula filters, such as CellValue(), FilterValue(), Hyperlink, LoadImage(), PageNumber().
...