Menu
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
558
Add total is disable if there is a expression or format string for value of cell. Just undo the expression and right click on the field you get it enabled and after adding total put your expression on the field agiain.
To add totals for a group, click Add Total on the shortcut menu for the group in the Grouping pane. To add totals for an individual cell in the tablix body area, click Add Total on the shortcut menu for the cell. The Add Total command is context-sensitive and enabled only for numeric fields.
Add Total and Subtotal to SSRS Report: Approach 1 To do so first, goto Row Groups pane and right-click on the Details will open the context menu. Let me open the Preview tab to check the Totals at the level of the detail. From the below screenshot, you can see that an extra column added with subtotals in SSRS.
you can just right click the column group and select the "Add Total" and click the "After" then you will got the sum on the right automatically: If you still have any problem, please feel free to ask.
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.
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
