
Dear all. I have data that looks like this:
 
Biller Cycle Jan Feb  Mar Apr May JuneAB       1   100 150 150 200 300 450JL        2   650 600 750 700 850 800JL        3   700 740 680 690 700 580IR        1   455 400 405 410 505 550IR        4   600 650 700 750 650 680IR        5   100 150 120 130 140 190IR        9   600 640 630 625 680 690
 
For each biller and cycle, I want to determine the six months average for Jan-Jun and also a 3-month moving average for Jan-Jun.
 
If a cycle number is skipped such as cycle 1 for biller JL, that just means there is no cycle 1 for biller JL. It's not missing data.
 
Any help would be greatly appreciated. Thanks.
_________________________________________________________________


	[[alternative HTML version deleted]]

