NgothoKariuki
New Member
- Joined
- Feb 27, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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
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