Lesson 5: Adding a Subtotal
You can add aggregate functions to the report. The following step adds a subtotal by sales person.
Click on the fourth cell in the last (Total Due) column and type the following expression.
=Sum(Fields!TotalDue.Value)
.gif "Subtotal expressionin table data region")
Next Steps
You have successfully added an expression that calculates a sum total of dollar sales for each sales person. Next, you will add formatting to improve the appearance of report data. See Lesson 6: Applying Formatting and Style.
See Also
Concepts
Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report
Other Resources
Expression Examples in Reporting Services
Using Report Functions in Expressions (Reporting Services)