title: SSRS matrix group by error
body: <p>I have an ssrs matrix with total in rows and months as columns .. something like this .</p>
  
  <pre><code>            Jan  Feb    March
  Total1
  Total2 
  </code></pre>
  
  <p>I can choose a month as a parameter and my matrix shows the results for the month and the two months before the current month.</p>
  
  <p>When I choose August :</p>
  
  <pre><code> I can see  June July August
  </code></pre>
  
  <p>When I choose September :</p>
  
  <pre><code>I can see July August September
  </code></pre>
  
  <p>But when I choose October </p>
  
  <p><strong>I see October August September</strong></p>
  
  <p>My client wants to see it as <strong>August September October</strong> </p>
  
  <p>I don't know the reason for this behavior .But can anyone help me with this ??</p>
  
  <p>I tried doing the sort for the tablix as follows :</p>
  
  <pre><code>=(Fields!Month.Value)
  </code></pre>
  
  <p>Month is a number like 1 for Jan, 2 for Feb. I add it as a sorting expression but I dont see any change in the sorting.</p>