Noetic said:
How Can I display the sub total work during a date range for the projects
under a resource pool for each resource?
Noetic
Noetic,
Since you are dealing with timephased data, there isn't a real easy way
to get the subtotal you want. I can think of two approaches. One uses
VBA and the other does not but it is more manual.
The best non-VBA solution I can offer is to use the Resource Usage view
in the pool file and then apply the Date Range filter. Display
Cumulative Work and subtract the value at the start of the period from
the value at the end of the period. Enter that value in a spare field if
you like for printout or saving with the file.
With VBA, the TimeScaledData Method can be used to grab data from any
time interval and place that data in a spare field. This can be done
with any view but it would probably have the best presentation on the
Resource Sheet or one of the Usage views.
John
Project MVP
