Hi,
I have created a view in MS Project 2013 that shows tasks grouped by Resource Name (via Views / Group By) similar to the standard 'Resource' Group By option. This works fine as long as there is only one Resource Name in the Resource Name column.
However, if there are multiple names in the Resource Name column, it creates a new grouping for each Resource Name combination in the view as opposed to putting each task into its respective Resource Name grouping.
For example, if Task 1 had Jon, Task 2 had Jon & Jack, and Task 3 had Jon, Jack, Jane, I would like to group by each Resource Name, so it shows a group for 'Jon' with tasks 1,2,3. A group for 'Jack' with tasks 2 and 3. A group for 'Jane' with task 3.
Instead I can only get it to show a view where the groups are (Group 1) 'Jon' with task 1 (Group 2)'Jon & Jack' with task 2 and (Group 3) 'Jon, Jack, Jane' with task 3.
Does anybody know how to arrange the grouping so all tasks for a Resource Name are grouped under that Resource Name, even where they appear as one of multiple names against the task please?
I have had a look at the Resource Reports but none seem to be what I am looking for.
Any help much appreciated.
Thanks
Jon.
I have created a view in MS Project 2013 that shows tasks grouped by Resource Name (via Views / Group By) similar to the standard 'Resource' Group By option. This works fine as long as there is only one Resource Name in the Resource Name column.
However, if there are multiple names in the Resource Name column, it creates a new grouping for each Resource Name combination in the view as opposed to putting each task into its respective Resource Name grouping.
For example, if Task 1 had Jon, Task 2 had Jon & Jack, and Task 3 had Jon, Jack, Jane, I would like to group by each Resource Name, so it shows a group for 'Jon' with tasks 1,2,3. A group for 'Jack' with tasks 2 and 3. A group for 'Jane' with task 3.
Instead I can only get it to show a view where the groups are (Group 1) 'Jon' with task 1 (Group 2)'Jon & Jack' with task 2 and (Group 3) 'Jon, Jack, Jane' with task 3.
Does anybody know how to arrange the grouping so all tasks for a Resource Name are grouped under that Resource Name, even where they appear as one of multiple names against the task please?
I have had a look at the Resource Reports but none seem to be what I am looking for.
Any help much appreciated.
Thanks
Jon.