SQLTeam.com | Weblogs | Forums

Displaying Row Headers for Subtotal Groups in the first column


I have a Tablix report in SSRS with multiple row groups. Every time I right click and add total for row group it adds the row for the total but it also places the "Total" Label under that group so I am ending up with ladder like, pivot like subtotals on my report.

What I need to do is to display correct subtotals at each group break, but display All of the total labels in the first column of the report. Any way I can accomplish this?