P6 nested filters

Dear Ramon,

You can find the desired tutorial at the following link: 

http://www.plannertuts.com/tutorials/mixing-and-and-or-options-in-primavera-p6-filters-1555/

Best Regards,

Kaif Mohsin

Thanks Kaif,

I have tried to follow those instructions, unfortunately I still don't get it.

The instructions state:

To indent the Or condition rows under the And condition rows, we inserted a new row below the last ‘And’ condition and assigned the ‘(Any of the following)’ option to it. All subsequent rows will have an Or option in the first column until we insert another ‘(All of the Following)’ option.

The above instructions suggest when you assign (Any of the following), 'all subsequent roles will have an Or option'.

When I assign (Any of the following), 'all subsequent roles will have an Or option'.

Do you know how I can get a mixture of 'And' and 'Or' ?

Regards,

Ramon

You have to define 2 separate filters.

You can not combine And / or in one filter.

Dear Ramon,

Sorry, for a late response. I think it would be better if you can give me the conditions of the filter you want and I will give you a step by step process for your better understanding.

For Raymond: Yes, you can combine 'And' / 'Or' in one filter. See the attached image

Best Regards,

Kaif Mohsin

Hi Kaif,

Here are the conditions of the filter I require, would you kindly provide a step by step process?

Suppose I wanted to look up a resource ‘Electrical Crew’ which has activity name containing either ‘Electrical Installation’ or ‘Cable Install’.

At the moment I would use 2 separate filters.

Filter 1: Resource Name = Electrical Crew

Filter 2: Activity Name = ‘Electrical Installation’ or ‘Cable Install’

Would be great if I could combine to a single filter

Thanks

Ramon

Kaif,

Your Image is not displaying.

Hi Ramon,

I hope you already got the solution but just in case you did not here is what I would suggest to you:

The filter lines should look like the following:

Line 1:                                 (All of the following)

Line 2:      Where                  Resources              equal               Electrical Crew

Line 3:      And                      (Any of the following)

Line 4:         Where               Activity Name         contains           Electrical Installation

Line 5:         Or                     Activity Name         contains           Cable INstall

The Line numbers above are only for explaining the format, you will not see or be able to enter the words "Line #".

Best Regards

Meraj Zia

Thanks for your response Meraj Zia,

Specifically, my problem is I don't understand how to get the 'Or' operator in line 5.

Would you kindly offer a step by step instruction on this?

Regards,

Ramon

Hi Ramon,

Your filter will exactly look like as it is described by Mr. Meraj. Here, is the Step by Step process:

Step 1: Assuming you are in the Filter dialog box, your first step would be to put 'Resources' equal to 'Electrical Crew' as shown in the below picture

Step 2: Next you have to 'Add' a new filter criteria and set the parameter to 'Any of the following'. So, at the end of Step 2, your filter will look like this:

Step 3: Further add two more criteria, for your activity name's of 'Electrical Installation' and 'Cable Install'. And at the end yor filter will look like this

Hope you can see the above picture's. If still you have any doubts, you are most welcome to ask.

Best Regards,

Kaif Mohsin