I have a Many-to-Many bridge table where I set the FK columns to Ref, which in turn automatically created a de-reference in each of my tables. This displays like this:
Ideally what I would like is rather than displaying the table with the two columns I would only like to display a table of the records on the โAnnual Reportsโ side. I attempted this by creating another virtual column in my Permits table with a formula of FILTER(โAnnualPermitDataโ,IN([id],[Annual Reports])). Unfortunately this did not return any records. My question is how I need to fix my formula and/or is there a more efficient way to accomplish this (something that would be less intensive from a query perspective)?
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |