Reputation: 1
SSRS Question - Is there a way to sum each cell value into the next colum. Here's what I'm trying to achieve. Colm B displays the sum of colum A upto that row
Col A Col B 1 1 2 3 3 6 4 10 5 15 6 21 7 28 8 36 9 45Upvotes: 0
Views: 795
Reputation: 2887
You want running totals. Everything you need is here.
Basically it will take each value from a data set and sum it up with the total from all previous values.
Some basic syntax: =RunningValue(Fields!A.Value,Sum,"yourDataSet")
Upvotes: 1