J
jas580
I have a query that returns the first 2 columns below. I want to add the 3rd
column:
Date Revenue Revenue Past 4 Qs
6/30/2007 100 730
3/31/2007 250 1170
12/31/2006 120 1150
9/30/2006 260 n/a (only 3 Qs)
6/30/2006 540 n/a (only 3 Qs)
3/31/2006 230 n/a (only 3 Qs)
The 3rd column should sum the current Q plus the past 3 Qs (Trailing 4Q).
I'm not sure how to accomplish this. Thanks for the help...
-jeff
column:
Date Revenue Revenue Past 4 Qs
6/30/2007 100 730
3/31/2007 250 1170
12/31/2006 120 1150
9/30/2006 260 n/a (only 3 Qs)
6/30/2006 540 n/a (only 3 Qs)
3/31/2006 230 n/a (only 3 Qs)
The 3rd column should sum the current Q plus the past 3 Qs (Trailing 4Q).
I'm not sure how to accomplish this. Thanks for the help...
-jeff