Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Ad hoc totals

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Ad hoc totals

Resolved · Low Priority · Version 2007

Reply Tue 21 Oct 2008, 16:24Delegate Des said...

Des has attended:
Project Intro Intermediate course

Ad hoc totals

If I have a big list of sub tasks assigned to 3 different resources, then I Autofilter the tasks to just show those assign to Resource#1, how can I get a sub-total that shows the total amount of days work for resource#1. The Total at the top (on the summary task) shows the total days for all sub tasks, and not just those assigned to resource#1

For upcoming training course dates see: Pricing & availability

Reply Thu 23 Oct 2008, 10:59Trainer Andrew said...

RE: Ad hoc totals

Hi Des,

Thanks for your question. You might find it easier to get the answer you are looking for by working from the Resource usage view. Each resource is listed with their tasks already grouped and a summary line showing the resources work.

You can either collapse the other resource lines so they are folded or apply a filter to hide them from the sheet.

I hope this helps - let us know if you have any additional questions.

Kind regards,

Andrew

MS Project articles

· Understanding Task Relationships In Microsoft Project
· Costs Are Easier To Control With MS Project
· Problem Solve On The Job With MS Project
· Managing And Understanding Tasks In Project
· Finding Your Way With The Project Map

Please browse our web site to find out more about
microsoft/project/courses and other Microsoft training courses.

Ms project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips