Hi all,

I need your help. I am trying to create rolling month table in SSRS report but I donít know I where I am going badly. May be because of I am new learner in SSRS.

Below is my data set & I showed how data looks in excel. I was doing this report in excel but my clients asked me to do in SSRS. I have given few excel tips for better understanding.


I need to create below table where data is rolling for 12 months. In excel I used few formulas to get data. I show in YELLOW color. I highlighted main group in Green color & sub group have white fill.


Can somebody please guide me step by step?