title: SSRS Report Builder 2nd Series in Stacked Column Chart Percentage of 1st Series Total
body: <p>I am currently using SSRS Report Builder 3.0 and need to make a stacked column chart with 2 series (side-by-side).  The category grouping (x-axis) should be a <code>month/year</code> while the values (y-axis) should be a percentage based on:</p>
  
  <p><strong>Series 1:</strong> sum of revenue (<code>ChargesTotal</code> dataset column) for the month (by special grouping to make the stacked column)</p>
  
  <p><strong>Series 2:</strong> sum of revenue from marketing (<code>MarketingChargesTotal</code> dataset column) for the month (by special grouping to make the stacked column)</p>
  
  <p>I've already tried using the <code>100% Stacked Column</code> which did not work because the second series (sum of revenue from marketing by month) needs to be divided by the sum of revenue for the month (series 1 total column sum), rather than <code>/100</code>.  And to my knowledge this cannot be done with a <code>100% Stacked Column</code> chart.</p>
  
  <p>I cannot figure out how to achieve the results I'm after.  Ultimately, what I want is the  series 1 column to sum to 100% across all months on the x-axis while series 2 should never be a 100% tall column because it will never accumulate to 100% of revenue received, but some percentage of that.  So series 2 should be a variable height column across the different months.</p>
  
  <p>This seems like a wordy explanation; but I don't know any other way to explain what I'm trying to do... Please get back to me with any questions and I'll do my best to be prompt with answers to assist in coming up with a solution.</p>
  
  <p>Thank you in advance for any guidance!</p>
  
  <p><strong>Update</strong></p>
  
  <p>After implementing the suggested answer I have the following results (I thought it better to display the results rather than try to explain them):</p>
  
  <p><img src="https://i.stack.imgur.com/ZEDIx.png" alt="enter image description here"></p>