Additive Filters?

S

SpaceCamel

Is there a way to apply a filter on top of another filter to get the combined
effect?

I have a set of filters for the responsible groups. I also have a filter
for different time windows. I need to combine the responsibility filter
with one of the time window filters. Adding to the filtering not replacing
it. I would hate to have a manually create every combination of filters.

Is this possible?
 
J

JackD

Yes, you can get this effect, but no, you have to edit the filter to include
all the criteria. Have you looked into using filters with user input? Just
enter a ? in the criteria and Project will prompt you to fill it in. (see
the date range filter as an example).
In visual basic it would be pretty easy to create this sort of filter.
 
G

Gérard Ducouret

Hello SpaceCamel,
You can display some specific graphical indicators such as red, yellow or
green lights, but not directly in the Total Slack field
Insert un Numberx column, right click its label
Customize field / Formula
[Total Slack]/[Minutes per day] (or something like that : I don't have the
english version in front of me.)
Click the Graphical indicators button
Less than.... 0 ... red light

Hope this helps,

Gérard Ducouret
 
S

SpaceCamel

I went ahead and wrote a VBA macro to do this.
I made a form with two select lists loaded with the available filters. You
just select the one's you want a click a Filter button. It applies the
filters and adds 1 to a temp number field each time. Then applies a filter
for task with 2 in the number field. Works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top