SSRS: Group Totals

Applying a sum within a group’s records.

As I illustrated in my Grouping article, grouping records that share an identical value for a column is a very helpful method to avoid repeating data and provide the user with a more intuitive manner to view records similar to each other.

In this example, I will show how to provide within each group a running sub total.

As you can see in the report, all records have a Quantity value for products in each order.


First, I’ll select the field for which I want to provide a sum of its values and add a new Total field after it.




Now I have a new Total field in the designer under the Quantity field.

I’ll right-align it and change its font weight to BOLD.

Executing the report show a product sub total for each company’s products in orders.

(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s