title: Sorting Cross Table in Spotfire
body: <p>I'm wondering if anybody knows how to sort 3 columns of data in a cross table, by the highest value for the 1st column.  For example:</p>
  
  <pre><code>column 1 = project # identifier
  column 2 = project customer name
  column 3 = project customer location
  value = project £ value
  </code></pre>
  
  <p>I need to show all 3 columns - but the first line should be the highest value project value, descending below. I understand that I could concatenate the 3 columns - but visually, I ma trying to maintain each column separately.</p>
  
  <p>Any ideas very gratefully appreciated!</p>
  
  <p>Thanks.</p>