Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Nested Filters

4 replies [Last post]
Jeff Waldrop
User offline. Last seen 35 weeks 2 days ago. Offline
Joined: 7 Nov 2018
Posts: 13
Groups: None

I find the filters in P6 to be very difficult.  When correctly built, they are wonderful but I can't seem to find a good desciption of how to build a nested filter.... I just spent about 1/2 and got what I needed but, it is trial an error.

 

Is there a tuturial somewhere out there on filtering data.

I am asking to show me all work by a Contractor equal to "Triad" and that is found in either Equip Class of "Mobilization" or "Demobilization" for a project....

Replies

Jeff Waldrop
User offline. Last seen 35 weeks 2 days ago. Offline
Joined: 7 Nov 2018
Posts: 13
Groups: None

Thanks Jerome, that worked for me....

 

 

Jeff

Zoltan Palffy
User offline. Last seen 15 hours 12 min ago. Offline
Joined: 13 Jul 2009
Posts: 2433
Groups: None

another option is to use more than ONE filter

Jerome Odeh
User offline. Last seen 7 weeks 4 days ago. Offline
Joined: 19 Jan 2004
Posts: 63

Jeff,

This should work for you

  1. Define 2 Activity Codes: Contractor & Equipment Class
  2. Add values to these Activity Codes, e.g.
    1. Triad etc to Contractor
    2. Mobilisation etc  to Equipment Class
  3. Assign these Activity Codes values to appropriate activities in your schedule
  4. Create a new filter with following criteria
    1. (All of the following)
    2. Where Contractor equals Triad
    3. And     (Any of the following)
      1. Where Equipment equals Mobilisation
      2. OR Equipment equals Demobilisation

If you still need a blog post to explain nested filters, send me PM with details of desired filters and I'll post a detailed tutorial on my blog.

 

=jerome

 

Kind regards,

Jerome

Anoon Iimos
User offline. Last seen 26 weeks 4 days ago. Offline
Joined: 22 Sep 2006
Posts: 1416
Filtering is very easy when you got "activity codes". Make your own activity codes for whatever you want to organize and assign the corresponding codes to your activities.