Create Queries – Filters
There are 4 filter types:
• Edit
• Column
• Value
• Parameter
We want to filter based on Value for our example. Then, we use the drop-down list to select IN.
The Effective Current Fin Year column has four possible values: Current, No, Previous and <blank>. Highlight the desired value (Current in this example), and press <Enter>.
It is possible to select multiple values.