Forum Discussion

lawsonbe's avatar
lawsonbe
Icon for Helper I rankHelper I
8 years ago
Solved

Visual Filter on Two Tables Related to a Third Table

I am having difficulty getting my visuals to filter by either of two related tables. My relationships look like this.     The problem stems from the fact that the survey I am basing the report...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Did you tried changing the cross filter for relation to both direction and I think that will do it. Cross filter option is available on relationship screen.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Did you tried changing the cross filter for relation to both direction and I think that will do it. Cross filter option is available on relationship screen.

  • lawsonbe's avatar
    lawsonbe
    Icon for Helper I rankHelper I
    8 years ago

    Thank you! I still had to delete one relationship. While I was trying to fix the issue I put an additional table in with the one field I wanted as my central piece of information. That is probably superfluous. Once I changed the direction to "Both", everything worked.