Multiple active relationships/sorting for reports

[Anonymous]

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 sort order.  The problem is that it works for one field, but if I want a second sort table, the second relationship won't become active.  

Independently, each relationship works fine.  However they can't both be active, but I can't figure out why.  

Even more confusing, I have a different table where I have no issues having two seperate sort tables.  

[parry2k]

@Anonymous 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

[Anonymous]

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.

[Anonymous]

can you show which columns are used in each relationship? 

[Anonymous]

In the table where it works, I have a 1:* relationship between column  "Index Providers" in table "Sort-Index Providers" and the same column in the table "ETF Characteristics".  Similar with "ETF Sponsor" in table "Sort-ETF Sponsor" and table "ETF Characteristics"

I tried this with "Company Characteristics" setting up seperate tables for columns "Size" and "Type", but that doesn't seem to work.

Thanks for getting back to me on this