Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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]
Tue, 2018-12-04 16:52
Jeff Waldrop
User offline. Last seen 1 year 24 weeks 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....

Top

Replies

Wed, 2018-12-05 21:09
#1
Jeff Waldrop
User offline. Last seen 1 year 24 weeks ago. Offline
Joined: 7 Nov 2018
Posts: 13
Groups: None

Thanks Jerome, that worked for me....

 

 

Jeff

Top
Wed, 2018-12-05 16:59
#2
Zoltan Palffy
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

another option is to use more than ONE filter

Top
Wed, 2018-12-05 14:42
#3
Jerome Odeh
User offline. Last seen 2 weeks 5 days ago. Offline
Joined: 19 Jan 2004
Posts: 102
Groups: Petro-Chem / Oil & Gas

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

Top
Tue, 2018-12-04 18:54
#4
Anoon Iimos
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
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.
Top