CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008-r2
rigamonk
rigamonk

Reputation: 1181

SSRS Totaling column with many groups

I have an SSRS report thats query returns many results. They are grouped to aggregate them by item group and division, as well as a couple of other groups. Whats happening is the total line is taking the total for ALL of the result lines instead of the grouped lines. I have tried adding a scope to the sum expression in the report but to no avail. All I really need it to do is sum up the visible columns. Heres a shot of my groups: enter image description here

enter image description here

enter image description here

If i run the report, look at the totals for the columns, they are way off: enter image description here

This should be 29,329 but it is (i believe) totaling everything outside of the groups. Is there a way to just sum the column so I can get the amount desired?

Upvotes: 1

Views: 727

Answers (1)

Trubs
Trubs

Reputation: 3032

You may need to recreate your groups again.

from the looks of your diagram, your total row is Outside your group Item_Process_Group, so the [sum(Sales_Quantity)] is summing all groups (as your comment suggest.

If your total ([sum(Sales_Quantity)]) was on the (empty)cell above where its displayed on the pic above, it should total correctly

Upvotes: 0

Related Questions