How to enable Add Total option in Tablix

Question

I had a problem of couting sum of grouped rows in a tablix. I posted it on stackoverflow. There I found the detailed answer by a user. But the problem is now, he is asking me to add "Add Total" in one cell of my tablix. Whereas I find no option of adding Add Total on every cell. In fact it is disabled on each cell except the cell that is coming under a group.

The person is using Italian IDE (Visual Studio) whereas my IDE is in english. Is there any difference between these two?

Please see the detailed post and reply if there is any solution.

I'll be thankful.

SSRS Sum in table group

score 8 · Answer 1 · edited Jul 16 '14 at 05:05

8

I had the same problem. I think the problem is if the field is not recognised as a numeric, then 'Add Total' field will be disabled. So to overcome this problem, first I inserted a row at the bottom of the table and then I converted the field into double in the expression as follows

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

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

edited Jul 16 '14 at 05:05

daniula

6,898
4
32
49

answered Jul 16 '14 at 05:00

Vivek Arkalgud

111
1
2

score 0 · Answer 2 · answered Sep 09 '17 at 00:44

0

Make column properties for which u want totals as double or decimal in dataset. Refresh report data in report designer. U will be able to see add total as enabled. Right click on column for which u want to add total and select Add Total.

answered Sep 09 '17 at 00:44

Anand Deshpande

1

score 0 · Accepted Answer · answered Jun 14 '11 at 05:56

0

I found the answer here

This is an alternate solution to my problem.

answered Jun 14 '11 at 05:56

asma

2,795
13
60
87

score -2 · Answer 4 · edited Jun 13 '11 at 15:43

-2

no there is no differnce between it

edited Jun 13 '11 at 15:43

Trufa

39,971
43
126
190

answered Jun 13 '11 at 14:11

G Arshiya

95
1
3
8

How to enable Add Total option in Tablix

4 Answers4