Group & Sort P6 - removing blank bands

just filter 

where whatever code is not equal to (leave the paramater blank)

i.e. for areas of a building

where area is not equal to (blank)

Hi Chris,

I just saw your post 10 year later.  I understand your question.  I have the same problem.  I think there is no simple switch in P6 even release 17 can get rid of group title such as "No xxxxx".  However, there is a workaround and easy to do.  First, create a new code value under your Activity Code dictionary.  Let Code Value = "." and leave Description blank.  Then use Global Change:

Where Code equal _____, Then Code = "." 

Make sure to add Code Value = "." first before global change.  You can repeat many times using the same template.

Good Luck

Eric

SZ,

Firstly please in future create a new topic for  such questions, rather than replying to a thread which is several years old.

Secondly it is not a good idea to give out your email address on these forums, as spammers are active here.

Thirdly, please don't post the same question multiple times in different parts of the forum. 

To create your codes, go to Enterprise > Activity codes > modify.

Use "add" to create a code called "Discipline", and then close the "Activity Codes Definition" window

Next select your new "Discipline" code from the drop-down box on the "Activity Codes" window, and use "Add" to add a code element for each discipline (civils, electrical, etc)

Once you have finished adding the code elements, close this window, and add a column to your gantt chart for your new activity code (you will find it under the activity codes section)

Now go through each activity and assign it with the relevant code (you can use the "fill down" function to speed this up)

Finally, you can now set up a filter to show only those activities which have a discipline code of "civil", etc.

Hi,

I have four building

One is CMH

2nd is MPP and so on..............

Under each and every building there are Electrical, Mechanical, Civil, Wood Working and Equipment sub-wbs are available.

Now my question is that if i need to know or i want to see only electrical activities by building wise then how can i do that? (i know that we have to define code but i don't know how to define them.....this is what i want to learn step by step) because this will enable me to check electrical activities building wise same as if i want to see CIVIL then i can sort by civil for every building....

Can anyone guide me step by step ........???

Plz snap shot will highly be appreciated........... at [email protected]

Raviraj is right, it does work only on several setup of grouping and not to all applications.



To serve your purpose Christopher, I guess you need to use filtering then.



Simply sharing. Thanks.

If u r using activty codes, then those bands will remain as it is.



Only and only if u r using WBS, then u can HIDE empty bands.

If the tick box of "Hide if empty" is ticked then it still doesn’t work, there could be some data under those bands that it cannot be hidden.



You may try filtering instead.

Hi Christopher,



In the Group and Sort tab or pop-up window, try ticking the tick box of "Hide if empty".



Hope it solves that problem.



In Service,

Ferdinand