SSRS sum(distinct()) equivalent
- by HurnsMobile
I am currently working with an SSRS 2008 report that returns a dataset similar to the following:
Job# ClientId MoneyIn MoneyOut
------------------------------
1 ABC123 10 25
1 ABC123 10 25
1 ABC123 5 25
2 XYZ123 25 50
2 XYZ123 25 50
3 XYZ123 15 15
Where MoneyOut should be equal…