How to enable the Add Total option in the Table

Question

I had a problem with highlighting the sum of grouped rows in tablix. I posted it on stackoverflow. There I found a detailed answer from the user. But the problem is that he asks me to add "Add Total" to one cell of my tablix. While I do not see the possibility of adding Add Total to each cell. In fact, it is disabled in every cell, except for the cell that falls under the group.

Man uses the Italian IDE (Visual Studio), while my IDE is in English. Is there a difference between the two?

Please see the detailed message and response if there is any solution.

I will be grateful.

Sum of SSRS in table group

Answer 1

I found the answer here

This is an alternative solution to my problem.

Answer 2

I had the same problem. I think the problem is that the field is not recognized as numeric, then the Add General field will be disabled. Therefore, to overcome this problem, I first inserted a row at the bottom of the table and then converted the field to a double expression as follows

=SUM(cdbl(Fields!GROSS_MARGIN.Value)) 

After running the report, I was able to see the expected total.

Answer 3

Create column properties for which u wants the totals to be double or decimal in the dataset. Update report data in report designer. U will be able to see the total included. Right-click on the column for which you want to add a total and select "Add Total".

Answer 4

there is no difference between him