Forum Discussion

Anonymous

Not applicable

8 years ago

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...

Resolver II

8 years ago

Can you please share what your data looks like. Maybe a sample might help

Anonymous

Not applicable

8 years ago

Anonymous
Not applicable
8 years ago
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)
Anonymous
Not applicable
8 years ago
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
- Anonymous
  Not applicable
  8 years ago
  Do you have a suggestion on how to do that?
  - Anonymous
    Not applicable
    8 years ago
    the Employee Table should have the break up of hrs spent for the phase/ per employee. You should include a new column Phase in the Emp table. Then you can make the relationship between these 2 tables basaed on the "Phase" column .
    
    Thanks
    Raj