Seasonal Index Forecasting Rolling Totals

[msi30502]

Hello,

I'm stuck! I want to create a report to that a rolling totals. Here's what I mean:

Year Quarter Quantity Rolling total
2013 1 10
2 20 100 ---> 100 = 10+20+30+40
3 30 140 ---> 140 = 20+30+40+50
4 40 180 ---> 180 = 30+40+50+60
2012 1 50 220 ---> 220 = 40+50+60+70
2 60 260 ---> 260 = 50+60+70+80
3 70
4 80

Also, I currently have two versions of the data. the first is in a crosstab. the second at a group footer (no crosstab). What's the best format to use? and, how would I create a formula that calculates rolling totals.

Look forward to your help.

 

[msi30502]

Sorry guys this didn't come out looking right. Please see attached file.

 

[msi30502]

By the way, I'm using CR 2008