Link to home
Start Free TrialLog in
Avatar of holemania
holemania

asked on

SSRS Sub Total Base on Group

I have a report in which I would like to add a sub total to the footer base on "Product Code" for each line.  Not sure how to go about doing this, but I had attached what I want.  Is this possible?

Item highlighted in Yellow and Green is what I am after.
User generated image
Avatar of prequel_server
prequel_server

yes, you would create a row group on the Product code and then you can put in the sub totals line in your table.

Another way is to insert a separate sub total table that groups by the product code
Avatar of holemania

ASKER

So would I just create 2 footer in my table, and then group it on product code?

Example:

User generated image
ASKER CERTIFIED SOLUTION
Avatar of prequel_server
prequel_server

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I was able to resolve the issue by installing SSRS 2008, since the grouping there was a lot easier.