We are implementing a portal using SharePoint 2010 for the company which has hierarchical regional structure. All company regions are contained in list and all users and all content have a link to this the item in this list. All data contains in the one site. We need to display lists data to the user ordered following way: 1) Data related to the current user's region; 2) Data related to the central office; 3) Data related to the other regions. Is it possible to implement such ordering using standard SharePoint abilities? Or what is the best way to implement such ordering if it is impossible?
As a simplest approach you can use 3 CQWP:
So the only thing you are required to do is to place user region's identifier in a correct place.