Hi All,

I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field  Total=(casecount+casecount1), which should look like the second screen shot. Here the “Total” needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice?

Thanks

​Hi All,I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field  Total=(casecount+casecount1), which should look like the second screen shot. Here the “Total” needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice?Thanks  Read More

​