Two sort criteria. How to display first those with a specific List (float) selection i have a View that provides a list of products(content type Product). This view has two sort criteria. The one is the "SKU" and the second is "New product". The "New product" is a List(float) field and the available options are N/A, Yes and No.

The view must show first the new products and then all the rest. New products are considered those that they have selected the option "Yes".

Is this possible? Any idea?

Thank
You can do it using views_query_alter. Find out what are the key values being stored from your list and then use them accordingly in the code below.

function yourmodule_views_query_alter(&amp;$view, &amp;$query) { 
  if ($view-&gt;name == 'shop' &amp;&amp; $view-&gt;current_display == 'page') {
     $query-&gt;orderby[0] = array(
           'field' =&gt; 'CASE table.type WHEN '1' THEN 1 WHEN '0' THEN 2 WHEN    
            ELSE 3 END');
  }
}