I have a table which keeps track if a member is active or not and the date they became active. I am trying to get a count of how many people activated for each month in each year. That part I have down. The part I am having trouble with is I also need to have a "running Total" of all active members at each month and year. Here is the code for the number of actives by month / year grouping.select count(distinct md.Member_ID) as MembersActive,datepart(month,active_date) as MonthActive, datepart(year,active_date) as YearActivefrom e911_member_detail as mdwhere md.status_ID = 5 and datepart(year,active_date) in ('2008','2009','2010')group by datepart(year,active_date), datepart(month,active_date)order by datepart(year,active_date), datepart(month,active_date)Gives meMembersActive MonthActive YearActive1 2 20081 3 20089 9 20087 1 200928 2 2009Which is great for the first part, number of members activated by month / year. What I also need though isMembersActive MonthActive YearActive1 2 20082 3 200811 9 200818 1 200946 2 2009aka the running total, by month/year. Ideally with a datefield like 2/1/2008 instead of month active / year active. So I can graph it in excel. But I'm not picky, and can work around the datefield part. Thank you
Running Totals Across Months / Years
Posted - 2010-08-13 : 15:53:41
