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
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
    LVL 4

    Accepted Solution

    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

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

    Author Comment

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    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.
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now