title: Calculate percentage of total columns based on total column in SSRS Matrix
body: <p>Looking to add a column in my SSRS Matrix which will give me the percentage from the total column in that row.</p>
  
  <p>I'm using the following expression, but keep getting 100% for my percentages (I'm assuming this is because the total is evaluated last, so it's just doing Total/Total?  </p>
  
  <pre><code>=FORMAT((Fields!ID.Value/SUM(Fields!ID.Value)), "P")
  </code></pre>
  
  <p>The field ID is calcuted within SQL, not SSRS.</p>
  
  <p>For example</p>
  
  <pre><code>Site   |  Value 1  |    %1   |   Value2  |   %2    |   Total
    1    |    20     |   50%   |    20     |   50%   |    40
  </code></pre>