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 to
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. the
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. if
anyone has any ideas on this i would be very grateful.
kind regards
--
Grollen
------------------------------------------------------------------------
Grollen's Profile: http://forums.techarena.in/members/grollen.htm
View this thread: http://forums.techarena.in/microsoft-project/1130737.htm
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