Forum Discussion

kesham's avatar
kesham
Frequent Visitor
7 years ago

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