Power pivot relationships not working

Zedders1471 1 Reputation point
2022-06-29T15:28:29.917+00:00

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

216147-image.png

However i still get the error message and incorrect results below

216193-image.png

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

Thanks216203-digram-view-issue.png216194-pivot-table-error.png

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,335 questions
{count} votes