Forum Discussion
UseRelationship
Hi Dellis81 ,
Sorry for the incorrect model I have send out, I tough I had saved the file but it did not happen.
Has I refered the changes are based on the accounts and transforming the relationships from many to many to one to many:
Has you can see in the image above I have create a new table Accounts (with distinct values) then I made the relationship between this table and the other to having a one to any (also the inactive relationship). There is also a change on the report headers table making it part of a one to many relationship.
All the opther relationships are the same.
Correct file attach.
Hi Dellis81 ,
Sorry for the incorrect model I have send out, I tough I had saved the file but it did not happen.
Has I refered the changes are based on the accounts and transforming the relationships from many to many to one to many:
Has you can see in the image above I have create a new table Accounts (with distinct values) then I made the relationship between this table and the other to having a one to any (also the inactive relationship). There is also a change on the report headers table making it part of a one to many relationship.
All the opther relationships are the same.
Correct file attach.
THANK YOU!!! Thank you again 🙂 Your revised relationship and new measures work great. AWESOME. I'm still working thru incorporating into my larger model - so far - exactly what I am needing.
I am finding some of my drill thru's and related interactive reports don't quite work - but suspect I need to go back and rethink how I have those measures setup.
But wanted to give you a big thank you before the day slipped away on me!!