SSRS SUM multiple column


is there any possible way the i sum the "Grand TTL Cases" by month? means only 1 cell in each month for "Grand TTL Cases"(25.56 + 13

September 3rd, 2015 7:31am

Hi Keong,

Check the below link. There they have calculated the difference but in your case it will be sum. Follow the steps and if you are not able to achieve then post us back

http://www.bi-rootdata.com/2012/11/calculate-column-difference-in-matrix.html

Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2015 7:51am

Hi Keong, 

According to your description, you want to sum the fields at the month level, right? 

In your scenario, you can insert a row below month group, and then use the following expression: 

=Sum(Fields!value.Value,"ColumnGroup")

The report design is like below: 

The result is like below: 

Due to the column is dynamically, if we add total to the detail row, it will produce the text boxes based on the number of column.  So we can only add total at the column group level (month group). 

If you have any other question, please feel free to ask.

Regards,
Shrek Li

September 3rd, 2015 10:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics