Grouping to show work / resource / phase

[Grollen]

hi all,

i have a project file with the following structure:

1. application a
1.1 design
1.1.1 activityx resourcea
1.1.1 activityy resourceb
1.1.1 activityz resourcea

1.2 build
1.2.1 activityx resourcea
1.2.1 activityy resourceb
1.2.1 activityz resourcea

1.3 test
1.3.1 activityx resourcea
1.3.1 activityy resourceb
1.3.1 activityz resourcea

2. application b
2.1 design
2.1.1 activityx resourcea
2.1.1 activityy resourceb
2.1.1 activityz resourcea

2.2 build
2.2.1 activityx resourcea
2.2.1 activityy resourceb
2.2.1 activityz resourcea

2.3 test
2.3.1 activityx resourcea
2.3.1 activityy resourceb
2.3.1 activityz resourcea


i would like to group by outline level 1 and by resources in order t
get the following view in the resource usage view:

1. application a
resourcea 34 hours
resourceb 50 hours

2. application b
resourcea 45 hours
resourceb 33 hours

however, no matter how i group it i can't get it like that way. th
closest i can get is:

1. application a
1.1 design
resourcea 3 hours
resourceb 5 hours

1.2 build
resourcea 14 hours
resourceb 20 hours

1.3 test
resourcea 5 hours
resourceb 7 hours


2. application b
1.1 design
resourcea 15 hours
resourceb 5 hours

1.2 build
resourcea 4 hours
resourceb 4 hours

1.3 test
resourcea 14 hours
resourceb 14 hours

i.e. one level to far down in the outline.

and that is by grouping by outline number and then resource name. i
anyone has any ideas on this i would be very grateful.

kind regard

 

[Jim Aksel]

There are two ways to do it, here is the quick way -- Insert a custom column
such as Text1. In that column enter the first digit of your WBS. You can do
it with a formula if needed. Then group by Text1.

If you do this on the resource usage view, you will need to run a macro
first to transder the data from Task view Text1 to Resource View Text1 (they
are different fields). An example is found on FAQ#37 at
http://project.mvps.org/faqs.htm

The other method is to change the "Define Group Intervals" on the grouping
dialog box.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com