Forum Discussion
Summarize by Rollup Task and Resource Group
Is there a way to write a report that groups resource groups under top level task and rolls up the summary values? Specifically:
- List all level two tasks
- Under each level 2 task, list the resource groups working on any task in that group
- Values SUM(Cost) and SUM(Actual Cost)
The output would look something like this:
L2 Task A
- R Group X [##] [##]
- R Group Y [##] [##]
L2 Task B
- R Group Y [##] [##]
- R Group Z [##] [##]
I've been able to group by Resource Group and by L2 Tasks but not both.
1 Reply
You mean something like this? (grouped on Resource Usage view)
To do it create a custom field
Text1="L2 - " & [Name]
Then group by Text1 (task) and then by Resource Group (assignment) and select the option to "group assignments, not tasks"
John
