Project 2010按WBS排序,然后按资源排序 [英] Project 2010 sorting by WBS then by resource
问题描述
我正在使用Project 2010(而非服务器),我的程序经理要求的报告应该看起来非常简单,但我无法弄清楚如何让Project显示我需要的数据。 我需要一个任务使用视图显示,首先按WBS分组任务,
然后按资源分组
我已经将它们分组到WBS的任务使用视图中。
例如,下一步是汇总它出现的每个WBS下的资源Engineer1。到目前为止,我有以下
WBS12345 设计代码计划 工程师1小时 50     50
WBS12345 编写代码 工程师1小时 50     100     50
WBS12345 测试代码指标 工程师1小时 25     25
我希望它做的是:
WBS12345
工程师1小时 125 NBSP;    175     50
当只分配了一个资源但是我有很多具有多个资源的任务而且我不知道如何分开时他们。
如果可以,请提供帮助。
Melissa2013,
无论如何原因WBS字段在"任务分配状况"视图中不可用作分组字段。因此,对于我的示例文件,我将WBS字段的内容复制到Text1,然后使用Text1作为第一个分组条件。对于第二个标准,即
资源名称字段,请选中按分配而不是任务分组的选项。这允许您选择分配字段作为第二个条件的字段类型。
查看该过程是否满足您的需要。
John
I am using Project 2010 (not Server) and my Program Managers are asking for a report that should seem very simple but I can't figure out how to make Project display the data I need. I need a task usage view display to group the tasks first by WBS and then by resource
I've grouped them in task usage view by WBS.
The next step is, for example, to rollup the resource Engineer1 under each WBS that it appears. So far I have the following
WBS12345 Design Code Plan Engineer1 hours 50 50
WBS12345 Write Code Engineer1 hours 50 100 50
WBS12345 Test Code Metrics Engineer1 hours 25 25
What I'd like it to do is:
WBS12345
Engineer1 hours 125 175 50
This works when only one resource is assigned but I'd have many tasks with multiple resources and I don't know how to separate them.
Please help if you are able.
Melissa2013,
For whatever reason the WBS field is not available as a grouping field in the Task Usage view. Therefore for my sample file I copied the contents of the WBS field to Text1 and then used Text1 as the first grouping criteria. For the second criteria, namely the Resource Names field, check the option to group by assignments not tasks. That allows you to select the assignment field as the field type for the second criteria.
See if that process does what you need.
John
这篇关于Project 2010按WBS排序,然后按资源排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!