title: SSRS Tablix Sorting w/Row & Column Group
body: <p>My matrix has a row group (QuestionText) and a Column Group (AnswerText).</p>
  
  <p>It looks like this:</p>
  
  <pre>
                  [AnswerText]
  [QuestionText]  [AnswerCount]
  </pre>
  
  <p>My Data looks like this:</p>
  
  <pre>
  QuestionText    AnswerText     AnswerCount
  Question 1      Yes            2
  Question 1      No             1
  Question 2      Yes            3
  Question 2      No             4
  </pre>
  
  <p>Which renders as follows:</p>
  
  <pre>
                  Yes            No
  Question 1      2              1
  Question 2      3              4
  </pre>
  
  <p>What I'd like to do is to sort by the Yes or No.  Please note that both the questions and answers are just examples, they answers could be flag colors &amp; red, white, blue...</p>
  
  <p>Is this possible?  I've seen someone say "it's hard".  I'm ok with hard, I just need to know how.
  <a href="http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/b4a242ce-e2de-463e-8732-a9f8abe493e4" rel="noreferrer">http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/b4a242ce-e2de-463e-8732-a9f8abe493e4</a></p>
  
  <p>Thanks for looking!</p>