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 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.
5 Replies
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
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 because you have a relationship with two separate tables, and can be active. Not sure what is the confusing part.
