CODEWITHSUNDEEP
reporting-servicesssrs-2012
Sheri G
Sheri G

Reputation: 47

Total Column of grouped rows in SSRS Report Builder

I have a grouped matrix that has customer drilldown total dollar amounts for every month. Each month is in a column, by customer row. I need to have a grand total for the year by customer on the far right that adds up the monthly charges by customer for the entire year. I can't figure out how to do this because when I try to add a Total Column to the right of Months it will only add inside the group so what I get is a column Total AFTER each month. I only want a year grand total at the very end. Thoughts much appreciated.Thanks!

Upvotes: 1

Views: 3488

Answers (1)

aduguid
aduguid

Reputation: 3195

You can add a total column by selecting the matrix then in the Column Groups section at the bottom right-click the column group | Add Total | After | like in the example below. Then add the expression in the new column. 

=Sum(Fields!total_amount.Value)

enter image description here

Upvotes: 2

Related Questions