Thursday, May 3, 2018

SSRS - Sum of Group totals only - sum of max

https://stackoverflow.com/questions/21677960/how-to-sum-the-group-totals-only

You can nest aggregate functions in SQL 2008R2 +

Set your total to

=Sum(max(Fields!OutputQty.Value,"Mo"))

Where "Mo" is the group name you want to group by first

No comments:

Post a Comment