CODEWITHSUNDEEP
reporting-servicesssrs-tablix
Renu
Renu

Reputation: 81

Adding total at the end of each row in the table in ssrs

How to add total for selected columns in the table in SSRS.Please see the attached image file below.I have tried "add total" from the group. But it displays at the end of group footer.I wanted the total for columns and displayed at the end of each row. Could anyone please help me to do that? TIA Total column at the end of each row

Upvotes: 0

Views: 911

Answers (2)

Renu
Renu

Reputation: 81

I have added sum of dataset fields instead of single value for the field.It might be because of grouping. In the expression editor I put Sum(Fields!ID30__59.Value)+sum(Fields!ID60__89.Value)+.. , it gives total value for the required columns in each row.

Upvotes: 0

Tab Alleman
Tab Alleman

Reputation: 31775

Add a column at the end of the row that has an expression that adds all the other columns together.

I don't know your column names, but assuming they were the same as your headers it would look something like:

=ReportItems!Current + ReportItems!30-59 + ReportItems!60-89 + ...

Upvotes: 1

Related Questions