Nested Filters in MS Project

  • Thread starter I''''MaScheduler
  • Start date
I

I''''MaScheduler

Is there a way to do Nested Filtering in MS Project. I know and have used
simultaneous filters in Primavera, like applying two or more filters in a
boolean "And" or "Or" conditions. How do I do that in MS Project.

I have separate filters for segregating data and would like to use a
combination of different filters to get to the report I need.

Please advice...
 
I

I''''MaScheduler

addendum/clarification to above question...

I do not want to use a single Filter and get lost in the nesting filtering
conditions as they will be too many, and I'm would rather like to separate
the filtering conditions and apply two or more filters simultaneously.
 
G

Gérard Ducouret

Hello,

Project / Filtered for / More filters... / New...
Field name : select a field
Test: select a comparison test
Value : a value or another field
Second row : And/Or....
If you skip a row, this row is grayed : you can create a hierarchy between
your And(s) and your Or(s)

Hope this help

Gérard Ducouret
 
I

I''''MaScheduler

Thank you Gerard
I'm already using that approach and it is becoming cumbersome for me to come
up with a huge filtering condition, to include and exclude certain task
attributes in One big filter.

As I researched, I couldn't find any information about using separate
filters simultaneously. Only other way I could see, is to apply an Auto
Filter and then drill down subsequently on the required columns.

I'm looking for an alternative to this approach, if I can capture my
subsequent drill down filtering conditions into a separate filters and apply,
atleast this way I will know which filters I applied, rather than looking
thru an individual filters or rather Auto filters to figure out my sequence.

Hope I did not confuse you with what I'm looking for. Any other thoughts
will be appreciated.
 
J

Jim Spiller

You cannot apply a filter to filtered data to futher narrow the data if that
is what you are looking for. You can only use a single filter on the data.
 

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