Hi, I need to create a report which looks like below Row groupings Applied: v Type Grouped by Type Person Grouped by Person Column Groupings Applied: v Month Name Grouped By Month Name Value Grouped By NothingCumulative Value Grouped By Nothing All the Group values are populated dynamically. The cumulative value should calculate as running value for all the months (e.g: Jan Cumulative value=Jan Value, Feb Cumulative Value=Jan Value +Feb value and so on) for each person. What expression can I use to find the cumulative monthly value? Thanks in Advance

Hi vijetha, you can use RunningValue function, where scope can be defined for the group Month Name. Please refer this link for using the RunningValue function: http://msdn.microsoft.com/en-us/library/dd255229.aspx http://www.keepitsimpleandfast.com/2011/09/running-totals-per-page-in-ssrs-to.html Regards Harsh

Hi, You need to use RunningValue, first note down the name of person group, suppose its PersonGrp then expression would be =RunningValue(Fields!value.Value,Sum,"PersonGrp") - Chintak (My Blog)

Hi, When i use the running Value function with MonthName as scope it returns blank values

when the Ruuning Value is calculated based on PersonGroup,it returns Incorrect totals.

Hi Vijetha, I think, RunningValue with scope of PersonGroup should work. I have also tested this with dummay data on 2008 R2 BIDS. Can paste a snap of the result you are getting? There may be some ordering issue of Month..- Chintak (My Blog)