Okay. So without seeing more of your App and your data structure, the best I can do is give you some general guidance…
- The general idea is that you use a Choice component as a filter
- The Choice component should write to a user specific column
- You then take the value in that user specific column and use a single value column to apply it to all rows in the table (or tables) that you want to filter
- Then use an if-then-else column to compare that single value column to the column in the data table that you are filtering by
- And finally, the output of the if-then-else column can be used in a filter condition in your Data Grid components
The above is just a general approach. The specifics might be slightly different, depending on how your data is structured and the types of values you are filtering. For example, filtering by date ranges sometimes needs special handling. There are also other approaches - using relations, for example. But again, without knowing more about your App I can’t really say which approach would be best for you.