How can I see a list of resources who have remaining work for a pr

S

Saibal Sen

As the project progresses, some of the resources complete their assignments
and no longer and are needed for subsequent phases. So, if I want to see who
are the remaining resources for the project and how much of remaining hours
they have, how do I create such a view ? I have tried creating
groups/views/filters to do them, but I have failed to get this view done.

While doing this I couldn't undestand what the field "Project" does as it
seems to display only one data - "Published" ? Is it the status of the
project as far as Published or not is concerned ?

I thought to group this info using the Enterprise Project Outline code, but
these fields are not available in the list of fields for creating a Group. I
have a outline code which provides the name of the Program to which a set of
project plans belong.
 
S

Saibal Sen

Hi Dale,

I created a view with the table used by the Resource Usage view with focus
on remaining work. But, my problems with this view are:

1. it shows all the resources that are part of the project team even though
they have no further tasks assigned to them
2. it shows all the tasks of other projects as well under the resource if
they are working on other projects as well

I want a very simple view as follows:

Project Name Resource Name Remaining Work
Project-A Joe 400 hrs
Project-A Sally 250 hrs
Project-B Cathy 125 hrs
Project-B Joe 300 hrs

First sort criteria is Project Name, then the resource name. I don't want to
see any resource that has Zero remaining hours in this view. I am doing all
of this in Project Pro environment, not PWA. Also, since I am going to open
one Project, if this view can show me the above ONLY for that project, that
is good enough for me.

Appreciate any lead on this. Thanks in advance.
 
G

Gary L. Chefetz \(MVP\)

Saibal:

Try creating this in Portfolio Analyzer. Drop the "Projects" Dimension and
"Resource" dimension in the Row Fields area in that order, then drop Work
and Actual work in the column fields area. You'll need to then add a
calculated field to calculate remaining work. Use the time dimension as a
filter.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 
S

Saibal Sen

Hi Gary,

Your suggestions were on the dot. I got what I wanted. Never would have
imagined that such a thing would have been hidden in the Portfolio Analyzer.

Thanks & regards,
Saibal.
 
Top