Dear All,
I have 20 projects, each with 10 activities.
I need a reprot to show the first "not started" activity ONLY of each project in the 20 projects.
I mean I need a reprot of the first record of not started activity so in total it should be 20 lines.
Appreciate your feedback,
Ismael
they are correct
make a global code call it my20 and give it a code value of 20
now go into each project and filter where activity status equals NOT STARTED
no sort by start date and assign the my20 code to the 1st activivity
no do this 19 more times for the other projects
then open all 19 projects and filter for the code
where my20 equals 20
Ismael, Primavera has no ability to directly show only the first non-started activity. you would need extra coding and filtering to achieve this as I mentioned in my previous post.
To remove the 100 lines down to 20 you need to collapse to the second level - however this will indeed show all 100 activities, but collapse them down to one grouping band per project.
I would group activities as Santosh has suggested and sort by ES date, then copy-paste into Excel and delete all but the first activity of each project. This should take only a minute or two.
Unless of course you need to report directly from P6, in which case you would need a fancy filter.
Cheers, KB
This showed all "not" started activities not the first one only. It showed 100 lines as each project has 5 uncompleted activities.
Open all projects, group by project as 1st level of grouping and then by activity status as 2nd level of grouping.
Apply a filter to only select activities with activiry status equals not-started.
Then collapse to r6he second grouping band. While this will display *all* bot started activities, it will be a report of only 20 lines and is the easiest way to produce this without needing complicated coding and filtering.