Relation issue

nbaudry

New member
Joined
Nov 10, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Dear Forum,
Since a couple of days, I am dealing with an issue of relation table.
I have 5 tables:
- Calendar
- Project information
- Load of the projects
- Capacity of the project manager
- Project manager table
I need to analyze the load/capacity of the project manager sort by priority.
My issue in the summary tab I see also the project of Pierre but he hasn’t any project in priority 2.
Many thanks for your help
N.

View attachment Demo.xlsx
 
A guess: instead of taking the Project Manager from the Names table, take it from the Project Table (the same one as the Priority field)?
 
Back
Top