OK, so you have a nice view in Project Center and it groups by a given field, we will call it Location. You get all your projects into the system and you notice that the grouping works as expected but the sort of the grouped headings is odd. Not even alphabetical.
Now, this is an “issue” that I'm sure has been around for as long as there has been a Project Server but I only just found it because on this engagement I’m on I broke with my normal process and did not prepare my custom field information the way I normally do. Normally, I gather up the lookup table values and set them up in Excel first. By force of an old habit from other systems I would either sort them in Excel or for those that did needed to be in a non-alpha sort I would put numbers in front of the values. Then I would put them into lookup tables.
I know that Project Server allows you to control the display order of the lookup table (see below) but I have always done this and habits are hard to break.
So what was my problem with the sort of my groups? Project Server views sort the group headings according to the display order set in the lookup table of the field you grouped on. My issue was that I had not put numbers in front of the values and I did not pick Sort Ascending. The default is By Row Number and that has always worked for me given my odd ‘pre sorting’ that is part of my normal routine. I went in and changed the sort order or my lookup table and my grouping was correct.
The moral of this story could be “Don’t break with your process” or maybe it is “Update your process”. I'm going to go with the idea that it is “Don’t break with your process!” :-)