Meurigif you only want to find passing thru Jan 2020 thenfilter allwhere Start is less than Jan 1 2020and finish is greater than Jan 31, 2020 also if you want activities that happen during Jan 2020 you will need to use 2 filters use the 1st one I listed and add a 2nd filterany where start within the range Jan 1 2010 (low value) and Jan 31 2020 (high value)or where where finish within the range Jan 1 2010 (low value) and Jan 31 2020 (high value)
KannanfilterANY where start is within the range (low value) 8/1/201 and 8/31/2012 (high value)or finish is within the range (low value) 8/1/201 and 8/31/2012 (high value)
MeurngYou have to at lest tell me what month you are looking to pass through ?I think you are looking for activity status equals in-progressthis will list any activities that have started but are not yet done.
Hi All,How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. eg:All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress Thanks in Advance Meurig
Hi All,How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. eg:All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress Thanks in Advance
Robert, your solution is very good, as we say at home very much better!BTW as far as I can recall MSP have such filter pre-defined under the name of Date Range Filter.
It doesn't matter much, but a slightly quicker way to filter for a particular period is;Where Start is less than 31-Aug-12And Finish is Greater than 01-Aug-12
How to filter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month?How in progress filter will find out if will be in progress a few months after Baseline DD?In progress between Aug. 1, 2012 - Aug. 31, 2012?I am not a P6 user any longer but maybe the above can be specified, in such case it should be enough to make the filter.
I dont know what your data date is but here is a solutionsolution #1filter whereParamenter is value high valuestart is within the range of aug 1, 2012 aug 31, 2012orFinish is within the range of aug 1, 2012 aug 31, 2012or activity status equals inprogress
Learn to use the operators, any activity that complies with Condition 1 OR Condition 2 OR Condition 3 OR Condition 4 will make it.==>> Do not use AND operator.BTW as long ago I stopped using Primavera each day it passes it becomes more difficult to understand it.
Hi rafael,i want to filter the activities as condition 4 like you mentioned above. i did by puting start date greater than or equal to august 1 and finish date less than or equal to august 30. but its not showing all the activities. it is showing only finished activities. i need all activities within the range best regards
hi,kannan, open ur project, go to group & sort,group by select start , and select a Month if group interval and then apply, ok. vty/Arneil
Rafael's reply is the answer to any filter lookahead date problem for your situation, condition 3 Filter specs should be: All of the followingStart is less than or equals 01-Aug-12Finish is greater than or equals 31-Aug-12
I do not use P6 but the following set of conditions can be a way:Condition 1: activities starting within the date range.Condition 2: activities finishing within the date range.Condition 3: activities starting before the date range and finishing after the date range.Condition 4: activities starting and finishing within the date range,Learn to use the operators, any activity that complies with Condition 1 OR Condtition 2 OR Condition 3 OR Condition 4 will make it.Best regards,Rafael
Meurig Glad I could help you
Meurig Glad I could help you
Thanks for you help Zoltan.
Thanks for you help Zoltan. Your solution works perfectly. Regards, Meurig
Meurigif you only want to
Meurigif you only want to find passing thru Jan 2020 thenfilter allwhere Start is less than Jan 1 2020and finish is greater than Jan 31, 2020 also if you want activities that happen during Jan 2020 you will need to use 2 filters use the 1st one I listed and add a 2nd filterany where start within the range Jan 1 2010 (low value) and Jan 31 2020 (high value)or where where finish within the range Jan 1 2010 (low value) and Jan 31 2020 (high value)
KannanfilterANY where start
KannanfilterANY where start is within the range (low value) 8/1/201 and 8/31/2012 (high value)or finish is within the range (low value) 8/1/201 and 8/31/2012 (high value)
I am looking to pass through
I am looking to pass through January when it will be planned to be in progress. Regards, Meurig
MeurngYou have to at lest
MeurngYou have to at lest tell me what month you are looking to pass through ?I think you are looking for activity status equals in-progressthis will list any activities that have started but are not yet done.
Hi All,How to fiilter the
Hi All,How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. eg:All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress Thanks in Advance Meurig
Hi All,How to fiilter the
Hi All,How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. eg:All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress Thanks in Advance
Robert, your solution is very
Robert, your solution is very good, as we say at home very much better!BTW as far as I can recall MSP have such filter pre-defined under the name of Date Range Filter.
It doesn't matter much, but a
It doesn't matter much, but a slightly quicker way to filter for a particular period is;Where Start is less than 31-Aug-12And Finish is Greater than 01-Aug-12
I posted the p6 answer
I posted the p6 answer
How to filter the activities
How to filter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month?How in progress filter will find out if will be in progress a few months after Baseline DD?In progress between Aug. 1, 2012 - Aug. 31, 2012?I am not a P6 user any longer but maybe the above can be specified, in such case it should be enough to make the filter.
I dont know what your data
I dont know what your data date is but here is a solutionsolution #1filter whereParamenter is value high valuestart is within the range of aug 1, 2012 aug 31, 2012orFinish is within the range of aug 1, 2012 aug 31, 2012or activity status equals inprogress
Learn to use the operators,
Learn to use the operators, any activity that complies with Condition 1 OR Condition 2 OR Condition 3 OR Condition 4 will make it.==>> Do not use AND operator.BTW as long ago I stopped using Primavera each day it passes it becomes more difficult to understand it.
Hi rafael,i want to filter
Hi rafael,i want to filter the activities as condition 4 like you mentioned above. i did by puting start date greater than or equal to august 1 and finish date less than or equal to august 30. but its not showing all the activities. it is showing only finished activities. i need all activities within the range best regards
hi,kannan, open ur project,
hi,kannan, open ur project, go to group & sort,group by select start , and select a Month if group interval and then apply, ok. vty/Arneil
HiCan you explain how to
HiCan you explain how to working filter?
Thanks a lot Rafael,
Thanks a lot Rafael, Ferdinand, Shareef.
Now its working.
Regards
Kannan
1.jpgThis is how the Filter
[[wysiwyg_imageupload:841:]]This is how the Filter Coniditions given by Rafael would be in P6 and it works !!! RegardsShareef
Rafael's reply is the answer
Rafael's reply is the answer to any filter lookahead date problem for your situation, condition 3 Filter specs should be: All of the followingStart is less than or equals 01-Aug-12Finish is greater than or equals 31-Aug-12
I do not use P6 but the
I do not use P6 but the following set of conditions can be a way:Condition 1: activities starting within the date range.Condition 2: activities finishing within the date range.Condition 3: activities starting before the date range and finishing after the date range.Condition 4: activities starting and finishing within the date range,Learn to use the operators, any activity that complies with Condition 1 OR Condtition 2 OR Condition 3 OR Condition 4 will make it.Best regards,Rafael