Sort bands in the chronological order

Hi,

I'd like to sort each level of my WBS by summary Start Date ; like using the "Sort bands alphabetically" option but with Start date..

Is there a way to do that?

Thanks

Gwenael

T
Tom Boyle 👤 Member for 19 years 6 months

Hi Gwenael,

You will need to start by abandoning WBS as the fundamental dimension of the layout.  (WBS is by its very definition a hierarchical structure for organizing the scope of work, not the schedule.  You can't re-sort it alphabetically in the layout either.)  While I don't see a giant problem with doing what you want, P6 is just not optimized for it (nor are other tools that I am familiar with).

The simplest approach is to group by Start, with the interval set to month, then sort within each band by start - then finish - in ascending order.  You can create activity codes or user-defined fields for organizing your activities independent of the WBS, and some of these might be pseudo-chronological (e.g. Phase1, Phase2, etc., or even "WBS Start Date")  Then you could group by these codes before sorting.  But like Rafael suggests, that might be more trouble than it's worth for you.

 

   

R
Rafael Davila 👤 Member for 22 years 3 months
  • It occurs to me you might create activity codes from your WBS if you cannot control sort directly from it.
  • Not available at a single click, time consuming but might do the trick. Every time you add an activity you might need to do it all over again as to greate the codes for the new activity.
 
  • Good Luck
G
Gwenael Delaleux 👤 Member for 10 years 10 months

It only sorts the activities in the WBS ; I would like to sort the WBS according to the summary dates of each level.

G
Gwenael Delaleux 👤 Member for 10 years 10 months

It only sorts the activities in the WBS ; I would like to sort the WBS according to the summary dates of each level.

R
Rafael Davila 👤 Member for 22 years 3 months

I do not use P6 but wonder if by selecting the column title Early Start you can sort by the column value, then you sould be able to save the Layout. The following is the dialog box I get if using Spider Project.

Sort by Columns photo sort_zpst6fpxlgu.jpg

 photo Layout_zpseqcfthwo.jpg

G
Gwenael Delaleux 👤 Member for 10 years 10 months

Thank you but it doesn't relly help..

In fact, I would like to keep the same group by options ; but just sort each level of grouping by Summary Start Date, as we can easily do by WBS Name (alphabetically).

G
Gwenael Delaleux 👤 Member for 10 years 10 months

Thank you but it doesn't relly help..

In fact, I would like to keep the same group by options ; but just sort each level of grouping by Summary Start Date, as we can easily do by WBS Name (alphabetically).

Z
Zoltan Palffy 👤 Member for 16 years 10 months

group by wbs 

then by start in the group interval put the internal either day week month

you might have to collapse the wbs to get what you want or select only show summary bars

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts