Forum Discussion
Multiple active relationships/sorting for reports
I have table that is working fine. However, for reporting purposes, I want to sort columns in a particular order ("Other" at the end, etc.) I have solved this by setting up a seperate table with s...
parry2k
Super User
Super UserAnonymous you can have only one relationship active between two tables, the reason it works for separate table because of two separate tables and one active relationship. It is correct working, although you can use inactive relationship in your measure by using userrelationship function that makes the inactive relationship to active, only in measures
Parry2k -- I will look at userrelationship. But I'm consfused why it works in the second picutre but not the 1st. The relatioships between the sort tables and the main table are similar, but works in one but not the other.
Thanks,
Raghu- parry2k
Anonymous because you have a relationship with two separate tables, and can be active. Not sure what is the confusing part.