Power pivot relationships not working

Zedders1471 1 Reputation point

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


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,668 questions
{count} votes