I have 4 diffrent tables that I want to mix and match data using pivot table function. Created relationships in data model diagram view, made sure all data types match and to avoid many to many issue i created a lookup table with unique values
However i still get the error message and incorrect results below
What is happeing and how do i get it to work? What is the point of creating relationships if they do not work and i cannot use fields from multiple tables in my pivot?
Attached screenshots in case images do not display