title: Getting SSRS Matrix Row Total for a Particular Column Value
body: <p>In Microsoft Sql Server Reporting Services 2008 R2 <strong>Matrix</strong>, I'd like to add a column that shows the percentage of one data item divided by the total count of that row's data items.</p>
  
  <p><em>Total</em>'s expression is <code>=Sum(Fields!Count.Value)</code>. How would I access the row's sum of Success from <em>Success Percent</em> so that I can do something like <code>=SUM(Fields!Count.Value WHERE Fields!Name.Value = "Success")/SUM(Total)</code>?</p>
  
  <pre>
  Adv.Name    Success         Failed  Total       Success Percent
  A           2               8       10          20%
  B           10              0       10          100%
  C           8               2       10          80%
              ----------------------
              Data Items
                                      -----------
                                      Column Grp Total
  </pre>
  
  <p><img src="https://i.stack.imgur.com/1DFCS.png" alt="Report in Design Mode"></p>
  
  <p>Thank you!</p>