Summary Task in Usage View - Filter Problem

[mmaxwell8]

MS Project 2000

Let say I have 3 resources A, B and C. A has 20 hours of work on task #1, B
has 20 on Task #2 and C has 20 on Task #3. If the tasks are linked and
indented under a summary task I can view the outline structure in the task
usage view and see the hours for all tasks. In this case, the summary task
will show a total of 60 hours and each task will show 20 hours.

If I filter the view for "using resource A" I will only see Task #1 and the
20 hours for resource A...which is what I would expect. The problem is the
summary row has not been filtered and will still show 60 hours. This doesn't
seem right. Does anyone one know how to fix this?

 

[JB]

It's still showing the 60 hours, because 60 hours is still the work that is
really assigned to that summary task.

If you're looking to sum hours by resources, you could view the "resource
Usage" view.

If you want to remain in the Task Usage Sheet, you could do a "Group By' in
the view...
In the Task Usage view:
1) Select [Project][Group BY][More Groups...]
2) Click the [New] button
3) In the "Name" field, type a name for the group, then
4) In the "Group By" field, select Resource Names
5) Click the [OK] button
6) Click the [Apply] button
7) Now you can filter on resource name ([Project][Filter for][Using
Resource] select "A" and click [OK]

 

[mmaxwell8]

Thanks for the quick response. This gives me work by task but I still lose
the "outlined" nature of the work because the summary task doesn't show for
each resource.
This is the task organization:

Build Phase
Part 1
Frame - Resource C (5 hours)
Subassembly1 - Resource A (2 hours)
Subassembly2 - Resource B (2 hours)
Subassembly3 - Resource A (2 hours)
Part 2
Frame - Resource C (5 hours)
Subassembly1 - Resource B (2 hours)
Subassembly2 - Resource A (2 hours)
Subassembly3 - Resource C (2 hours)

I need to filter the work (manhours) of all subtasks that a specific
resource is working on while maintaining the outline. I can then cut/paste
into excel. I would like to see for resource "C":

Build Phase 12
Part 1 5
Part 2 7


Is this possible? When I filter task usage for Resource "C" I get:

Build Phase 22
Part 1 5
Part 2 7

It's still showing the 60 hours, because 60 hours is still the work that is
really assigned to that summary task.

If you're looking to sum hours by resources, you could view the "resource
Usage" view.

If you want to remain in the Task Usage Sheet, you could do a "Group By' in
the view...
In the Task Usage view:
1) Select [Project][Group BY][More Groups...]
2) Click the [New] button
3) In the "Name" field, type a name for the group, then
4) In the "Group By" field, select Resource Names
5) Click the [OK] button
6) Click the [Apply] button
7) Now you can filter on resource name ([Project][Filter for][Using
Resource] select "A" and click [OK]

MS Project 2000

Let say I have 3 resources A, B and C. A has 20 hours of work on task #1,
B
has 20 on Task #2 and C has 20 on Task #3. If the tasks are linked and
indented under a summary task I can view the outline structure in the task
usage view and see the hours for all tasks. In this case, the summary task
will show a total of 60 hours and each task will show 20 hours.

If I filter the view for "using resource A" I will only see Task #1 and
the
20 hours for resource A...which is what I would expect. The problem is the
summary row has not been filtered and will still show 60 hours. This
doesn't
seem right. Does anyone one know how to fix this?