Add Exclude Filtered Rows option for filtering related Data Tables.
Currently, the three options are:
Include Filtered Rows
Exclude Filtered Out Rows
Ignore Filtering
In a scenario where users need a anti-join-esque behaviour, none of existing options work; thus, the need for the requested option.
Data Table #1 values: [A, B, C, D]
Data Table #2 values: [A, C, E, F]
Given:
The two tables are related.
Table #1 is filtered to [A, B]
Goal is for Table #2 to show [C, E, F]