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.

Sorting Activity Code groupings by the start date of the activities within

2 replies [Last post]
Brian Walkin
User offline. Last seen 19 weeks 47 min ago. Offline
Joined: 27 Dec 2017
Posts: 33
Groups: None

I have created a view which has two levels of activity codes - Example (for illustration only) level 1: Building and level 2: Work Type. This is not the WBS. Using grouping and sort I selected the two levels and checked the box to "show summaries only". When I view the result I am looking at the summary bars at Work Type level for each building.

The problem is that the work type is not always consistent e.g. if it was: 1. Under Ground services - 2. foundations - 3. framing - 4. roof- 5. Paving; I could set my activity codes in that order. However this not always consistent in this project example the Underground services can be performed after the building construction or maybe the paving is performed after underground services but before foundations and so I need to sort the activity codes by the start dates of the activities within that activity code grouping.

How can I achieve this.

Thanks

Replies

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

to sort within a group just click on the top of the start column

also under group there is an option for sorting. ON the right select add then seleect start date

The other option is to give an chnage the of the grouping itself by chaging the order with in the activity code dictionary 

another way is in the grouping to do not select summarize instead select view then summarize to level and pick a level that you want to summarize to

 

Rafael Davila
User offline. Last seen 21 min 52 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Take a look at the following link, it might give you some clues.

How to Group and Sort By Dates | P6 Consulting