elcolombicheric
New Member
- Joined
- Nov 10, 2013
- Messages
- 1
[TABLE="width: 436"]
<tbody>[TR]
[TD="width: 87, bgcolor: transparent"][/TD]
[TD="width: 49, bgcolor: transparent"]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Location
[/TD]
[TD]Project
[/TD]
[TD]DISCIPLINE
[/TD]
[TD]NAME
[/TD]
[TD]Total Hours
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]Jane
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]Jane
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]Doe
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]Doe
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
How could I consolodate a similar report by taking values in the Project column and the persons name and adding the total hours worked for that particular Project. Instead of having multiple lines with repeated Project Numbers for an individual, I can report it on one line as a total for the person and the Project. For instance John would reflect 2 hrs total for the hours worked on Project 1 and 3 hours total for the hours worked on Project 2. I want to keep the same formatting just consolidate the information by Project and Name and giving the totals for that particular combination.[/TD]
[TD="width: 167, bgcolor: transparent"][/TD]
[TD="width: 201, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD="width: 87, bgcolor: transparent"][/TD]
[TD="width: 49, bgcolor: transparent"]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Location
[/TD]
[TD]Project
[/TD]
[TD]DISCIPLINE
[/TD]
[TD]NAME
[/TD]
[TD]Total Hours
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]John
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]Jane
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]1
[/TD]
[TD]xxx
[/TD]
[TD]Jane
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]Doe
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]2
[/TD]
[TD]xxx
[/TD]
[TD]Doe
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
How could I consolodate a similar report by taking values in the Project column and the persons name and adding the total hours worked for that particular Project. Instead of having multiple lines with repeated Project Numbers for an individual, I can report it on one line as a total for the person and the Project. For instance John would reflect 2 hrs total for the hours worked on Project 1 and 3 hours total for the hours worked on Project 2. I want to keep the same formatting just consolidate the information by Project and Name and giving the totals for that particular combination.[/TD]
[TD="width: 167, bgcolor: transparent"][/TD]
[TD="width: 201, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]