[Last Call] Learn how to a build a cloud-first strategyRegister Now


When I use filters on MS project the total rows show totals for the whole project, not filtered results.  How can I change this?

Posted on 2006-04-06
Medium Priority
Last Modified: 2013-11-15
I have an MS project 2000 file with three resources:  Bill, Ted and Mary.   Bill is working 10 hours,  Ted 100 and Mary 1000.  When I look at the summary task on the project, the total work hours is 1110.   So far, so good.  I apply a filter on Resouce = Bill.   The summary hours is still 1110.  I want the summary hours to be 10, ie to only show Bills hours.

Do any of you gurus know how to do this?  It seems like such an obvious requirement, I'm surprised I can't find any option for this?
Question by:chinguetti

Accepted Solution

MSProjectGeek earned 200 total points
ID: 16402518
Filtering has this idiosyncrasy

Workaround, if you create a custom field Tools-Customize-Fields and then use the Group By feature, you'll find that the totals for the groups do correctly show the sum of those items in the group.  Actually you may be able to do what you want without a custom field, just group by resource and all Bill's hours will be totalled in the Bill group
LVL 35

Expert Comment

ID: 16412139
You can see the summary work for each resource at View - Resource:Usage

Author Comment

ID: 16415020
Thanks MSProjectGeek,  I didn't know I could add stuff to the "by groups" filter list.  This is exactly what I need.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question