I have a table as follow:
No Placestart Placeend
1 DK USA
2 UK USA
3 USA DK
Now, I want a dimension called Country, which selects either of the rows where a value exist
In SQL it would be ex (SELECT * FROM table WHERE placestart = 'USA' OR placeend = 'USA)
So, when I select USA in the dimension all 3 rows are listed, as USA is included either in placestart or placeend.
If I select DK row 1 and 3 is selected etc...
Is this somehow possible?
View Complete Post