Incorrect Total Sum when Filtering

[Jim Aksel]

MS Project 2003. I am in Resource Usage View. I have another column
displayed such as %complete or a text field, say Text1. All the resouce
hours total up for Work just fine. Howerver, if I apply a filter ... say I
auto filter on one of the items in Text1 or %complete, then the correct
filtered lines show up, but the total values remain unchanged.

I want to be able to run a filter and have the total reflect the total of
the filtered values only, not all values. How? Or is this simply a feature?

 

[Jan De Messemaeker]

Hi,

Grouping, rather than filtering, is what you need.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

MS Project 2003. I am in Resource Usage View. I have another column
displayed such as %complete or a text field, say Text1. All the resouce
hours total up for Work just fine. Howerver, if I apply a filter ... say I
auto filter on one of the items in Text1 or %complete, then the correct
filtered lines show up, but the total values remain unchanged.

I want to be able to run a filter and have the total reflect the total of
the filtered values only, not all values. How? Or is this simply a

feature?

 

[Jim Aksel]

I tried Grouping yesterday after your referal to FAQ37. I added the code to
my file and inserted Text5 into both my Resource Usage View and my Gantt
chart view. It worked great!

However, when using Group By on the new Text5 field, in Resource Usage View,
it just gives me one group ... unmatched with all my tasks in it.

Any other advice would MMD (Make My Day)

 

[Jan De Messemaeker]

Hi,

Do you want to group on the assignment's text5 field?
If so in the group definition:
- Check the box "Group Assignments not resoruces"
- In the field box select assignment

HTH

 

[Jim Aksel]

Been there, it is not working. Let's take this off line, if you don't mind.
I can be reached at (e-mail address removed) or 714-525-2300 x209. Pop me an
e-mail and I'll send you the file and we can maybe stare at it together.

Jim Aksel