Forum Discussion
kesham
7 years agoFrequent Visitor
filter a table on 2 columns with a OR
Hi,
I have a table related to a delivery job with named "delivery" 3 culumns: "load day", "unload day", weight
I also have a table names "date" with all the days of the year (put in a segment visual)
what I want is to select specific day from "date" and to show in a table every related "load day " AND "unload day"
I tried with relationship between "day" and "delivery" tables but with that I can only filter on "load day" OR "unload day". unable to make both relationship.
how could I do that?
In short if it would be possible to pass the selected day on "date" as a filter on both load and unload to ha both lines on the filter
can someone help me ?
kind regards
1 Reply
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.