Hello, I have a big model with a large number of table loaded from databases. I create a Master Calendar, so all the Date fields of the different tables are linked with that.
I illustrate my problem with an example:
Table A:
Date
ColX
01/01/2017
DataA
02/01/2017
DataB
...
...
Table B:
Date
ColY
01/01/2017
DataC
02/01/2017
DataD
The two tables are not linked together, only are linked by the master calendar.
So if I select "DataA" from table A, it filter all rows of table B where the date != '01/01/2017' and I don't want this. I want to show entire table B data. Of course, if I don't use the Master Calendar I solve the problem but I want to use Master Calendar.
