IvanWeiss
6 years agoQrew Captain
Cannot Dynamic Filter in Many to Many Relationship
I am creating a table for all of my Company Procedures so that we can work on documenting them for new and existing employees. As this list can get a bit long I want to be able to associate a Department with them so if I work in Accounting, for example, I can dynamic filter all of the procedures just affecting Accounting.
Here is my structure:
Departments < Department Procedure Join Table > Procedures
I created the join table because each department can have many procedures and each procedure can have many departures. On the report I can only do the following. I cannot seem to expose the department field as a dynamic filter for some reason. Not sure what I did wrong here or what is wrong with my logic.
------------------------------
Ivan Weiss
------------------------------
Here is my structure:
Departments < Department Procedure Join Table > Procedures
I created the join table because each department can have many procedures and each procedure can have many departures. On the report I can only do the following. I cannot seem to expose the department field as a dynamic filter for some reason. Not sure what I did wrong here or what is wrong with my logic.
------------------------------
Ivan Weiss
------------------------------