You will need to use the Hotel ID field somewhere in the viz to "activate" the relationship.Relating disparate data sources functions differently from a typical Join operation. Hope that helps.
How can I use it without really changing the view?
I have one data set with hotel details, and a second one with reservation details. Linking field is hotel ID.
I want to show revenue by hotel type (revenue comes from reservations, hotel type comes from hotel details). But I don't want to break it down by Hotel ID. Is this possible?
Abraham, Try putting it on the level of detail shelf.