title: SSRS - Calculation of rows using column total
body: <p>I'm using a matrix tablix style to display a range of date based on date range parameter. The image below indicates CAT1 to CAT20 with Case Count total. I need assistance on how to calculate the Case % base on overall Case Count. </p>
  
  <p>For example: Total Case Count = 3,393, CAT1 = 11, Case % for CAT1 = 0.324% (11 / 3,393). I am having difficulty figuring a way to calculate Case % using the overall Case Count.  </p>
  
  <p>I wrote a code in SQL, but when I add it in SSRS dataset it is timing out. Thanks in advance.</p>
  
  <p><a href="https://i.stack.imgur.com/ID9eo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ID9eo.jpg" alt="enter image description here"></a></p>
  
  <p>Here is the 4 days data (Note: This is the actual report). I have 2 datasets 1) RSNCD_SUB is by date, counting case by category (Reason Code). 2) RSNCD_TTL is by date, counting cases by data, and I'm using tablix matrix.
  <a href="https://i.stack.imgur.com/lcsMU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lcsMU.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Rgkkw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rgkkw.jpg" alt="enter image description here"></a></p>
  
  <p>Below is the comparison when running the report using multiple date vs single date. As you can see the calculation on a 1 day run is correct, but it is incorrect on a multiple day run.</p>
  
  <p><a href="https://i.stack.imgur.com/h2YBQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h2YBQ.jpg" alt="enter image description here"></a></p>