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...
As per the Emp table, Sam spent 66 hrs and Patrick spent 192 hrs for meeting, but the master table shows only 12 hrs spent for meeting. This is wrong, The Emp table needs the breakup on the hrs spent for each phase.
For example, you may have multiple rows for Sam, like this:
Sam -6 hrs- meeting
Sam- 15 hrs -Design
Sam -45 hrs - Implement etc.
Thanks
Raj
Ok, I did that. But it still is not interacting. I was hoping to click on a column in the Cost by Phase graph and have the visuals with the employee information adjust based on that