Forum Discussion
Multiple Relationship Reporting
I'm not sure it's the most elegant solution, but one way is to create a related table. The way I did it was:
1. Under Transform Data, right click on the table and choose "Reference" (this way it does not take up more space) and renamed the new table related to the table. Apply and close.
2. In the model, create a relationship between "How" in the tables, this will be many to many, but change it to an address, so the table filters related table.
3. Who data segmentation comes from Table, then you have a table with those values.
4. The second table is the data related to the table.
I'm not sure it's the most elegant solution, but one way is to create a related table. The way I did it was:
1. Under Transform Data, right click on the table and choose "Reference" (this way it does not take up more space) and renamed the new table related to the table. Apply and close.
2. In the model, create a relationship between "How" in the tables, this will be many to many, but change it to an address, so the table filters related table.
3. Who data segmentation comes from Table, then you have a table with those values.
4. The second table is the data related to the table.
Genious solution!!! The only issue I had was when adding other details, it added in blanks which doubled the costs. But I just filtered out blanks to solve. Thank you so much.