Apologies for the long explanation in advance since I cannot share the data.
I have a dataset that has 5 fields, each one of these are basically a Boolean indicator. Let's call them fields A to E. Then there is column F, which basically is populated by values A to E based on whether or not A is true, B is true so on and so forth.
Field E is a calculated field which is True if any of the field A-D are true.
So now comes the dashboard. I have created a dynamic expression to calculate the counts of "True" for each field that I can use in a list. Essentially a geometry less featureset with the following value pair rows.
A - 50, B - 20, C -10, D-10, E-5
Here comes my problem: What I want to do is someone selects A, I want to display any features where A=True but I can only filter by column F using the first field in the dynamic expression as the source.
Is there anyway to accomplish this?