Forum Discussion
data relationships
I have two different tabs on excel. One has employees and amount of hours worked per employee. Another has phases of a project and the amount of hours in each phase as well as the total number of hou...
Can you please share what your data looks like. Maybe a sample might help
The "Actual Work" column in the first photo is the same amount of hours as the "Total Work" column in the second photo (with the employee data)
We cannot derive that as the current table design has no relationship between these 2 tables and there is no way to find how many hrs Sam spend his effort in each phase AND who contributed for the 12 hrs meeting. The design needs to be changed, to have the relationship and break up to find the above details.
Thanks
Raj
Do you have a suggestion on how to do that?