SSRS: Running total
Step 1 Create a data source and a dataset
Add an extra field for the Running total.
Add an expression.
Go to Common Functions > RunningValue
Add RunningValue function
Add field you want the create running total for. (Fields!Units.Value)
Add a name of the aggregate function (SUM)
Specify the scope as string, means, it needs to be in double quotes. In this case it is the whole dataset ("DataSet1")
I have a field called Region and I want to create a running total by region.
4.1 Add the Region column into the table.
4.2 If you want to create the running total by region, the data need to be grouped by Region first. Otherwise you will get an error.
Add a column for cumUnitsByRegion, add expression.
Use RunnigValue function to create the running total by Region.
If you are creating a running total by a subcategory, data needs to be grouped by the subcategory first.