It is possible to add a filter that applies a condition based on any data from either the source table or any of its parent records. Follow the steps in the Adding a Filter section, then follow the below steps;
- Ensure that the Filters tab is selected.
- Click on the Add button at the bottom of the window to add a new filter.
- Select the Group that the filter condition is going to be based upon.
- Select the Field from the Group that the filter condition is going to be based upon.
- Select the condition and the value that the condition is going to be based upon. For example, to filter out all records other than U samples, select Equals as the condition and enter a value of U.
- Select OK to close the dialogue.