Forum Discussion
Table Relationship Excluding Values
OK, here's a very simple version. The Master table has an ID for all MBR. The Conditions table has a Many-1 relation with the Master. A member can have 0, 1, or more Conditions.
The Export Summary should have a row for each row in the Master and any matching data in the Conditions.
The desired result would look something like this:
OK, I think I have solved the issue in my real (much more complex) example. Turning on Show Items with No Data fixed the sample setup shown above.
But, what I think has fixed the original issue is the ordering of the columns. I had some columns from table 1, then some from table 2, more from table 1 and finally some from table 2. If the columns are ALL set to Don't Summarize, BI is essentially performing a "group by" on each column, and by having them in the "wrong" order, I was getting unintended consequences.