CODEWITHSUNDEEP
reporting-servicesssrs-2008reporting
Sandeep Mogaveer
Sandeep Mogaveer

Reputation: 57

How to get Distinct Sum at SSRS Expression?

Tabel Data and Expected Result 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.

Thanks in Advance

Upvotes: 1

Views: 5926

Answers (1)

Sandeep Mogaveer
Sandeep Mogaveer

Reputation: 57

Resolved. Grouped by "Promotion Name". Then Write Sum formula as SUM(Max(PromotionAmount,"GroupName"))

Upvotes: 3

Related Questions