title: How to get Distinct Sum at SSRS Expression?
body: <p><a href="https://i.stack.imgur.com/8l8JL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8l8JL.png" alt="Tabel Data and Expected Result"></a>
  Please check the picture file attached. I want to get distinct sum of a column(Promotion Amount) based on another column(Promotion Name). At SSRS.
  Cannot do this grouping sum at t-sql Level .. Need to be done in SSRS only.. through expression.</p>
  
  <p>Thanks in Advance</p>