Forum Discussion
adrien5555
Helper II
Helper IIInactive relationships : When multiple relationships are to be done
Hi all, All the data must be seen by date, and by location, basically. So based on your good advice, I created a "date" table with all dates, and a "country" table with all countries. All da...
adrien5555You need to make one of the below relantionship "Single" filter direction istead of "Both".
Dates 1:* BusinessReportAmazom
or Continents and countries 1: BusinessReportAmazom
The problem if the relation was active then the filters from this table could went through Dates or through Continents table and there is no way the engine to know which should follow so it gives an error.
Great solution konstantinos @!! It worked for me as well.