Pivot Table Displaying Repeat Values in Columns

[NgothoKariuki]

Table 1 contains print list with user names (below)

Table 2 contains user names and departments(below)

Created a model and related the two tables using username in both tables(below)

When I pivot from the model, it repeats a value for the different departments per person (below) - The User Only belongs to one department (e.g Admin or Kindergater) But here the value repeats itself across all depts!

Please help

 

[RoryA]

that's what data relationships ARE

Not in the data model. They filter from the one side to the many. They don't work the same way you might expect if you are coming from a database background.