SSRS Tips and Tricks Recursive Sum of Fields

Dear All,

A while ago, I posted on Conditional Summing Group Totals in SSRS


Here's another small but useful tip if you ever want to do a recursive sum then we have an optional parameter in the SUM function

Syntax :

Sum(expression, scope, recursive)

 
Example :
Sum(Fields!ORIGINALFORECAST.Value,"PROJID",Recursive)

Read more here in this msdn article