title: Custom sort ssrs matrix
body: <p>I have a matrix report that has four columns and is sorted descending on the last columns values. The problem I have is when there is a tie I would like to use the value in the prior column or the one prior to that if there is still a tie. Below is a sample of my output and what I'm after is for Nissan and Renault to be switched. This is the expression I'm currently using in my group sort</p>
  
  <pre><code>=IIF(Fields!YearSold.Value = MAX(Fields!YearSold.Value),0, Fields!UnitSold.Value)
  
              2009    2010    2011    2012
  Make        Units   Units   Units   Units
  Chevy       1,104   842     811     927
  Volvo       1,054   905     792     879
  Ford        1,638   923     718     809
  Nissan        918   794     725     791
  Renault       840   698     759     791
  Mazda         722   535     460     621
  Lexus         786   590     551     563
  </code></pre>