List:General Discussion« Previous MessageNext Message »
From:Barry Newton Date:August 3 2006 3:43am
Subject:Re: Running Totals?
View as plain text  









At 11:10 PM 8/2/2006, Peter Brawley wrote:
>Barry
>
> >It would make life easier if I could also show a column
> >with the cumulative count for each month.
>
>Set @cum - 0;
>Select
>   Monthname(DatePaid) Month,
>   Year(DatePaid) Year,
>   Count(*) as Registrations,
>   Extract(Year_Month from DatePaid) AS Monindex,
>   @cum := @cum + Count(*) AS 'Year to date'
> >From capclave2005reg
>Where year(DatePaid)=2004 and (amount > 0 or Dealer = 'Y')
>Group by Monindex ;
>
>PB

Looked promising, but gets me the following, which isn't quite right:

+-----------+------+---------------+----------+--------------+
| Month     | Year | Registrations | Monindex | Year to date |
+-----------+------+---------------+----------+--------------+
| October   | 2004 |            23 |   200410 |           23 |
| December  | 2004 |             5 |   200412 |            5 |
| January   | 2005 |             9 |   200501 |           14 |
| February  | 2005 |            11 |   200502 |           16 |
| April     | 2005 |             2 |   200504 |            7 |
| May       | 2005 |            48 |   200505 |           53 |
| June      | 2005 |            45 |   200506 |           50 |
| July      | 2005 |            10 |   200507 |           15 |
| August    | 2005 |            17 |   200508 |           22 |
| September | 2005 |            58 |   200509 |           63 |
| October   | 2005 |            97 |   200510 |          102 |
+-----------+------+---------------+----------+--------------+


Barry


Thread
Running Totals?Barry Newton3 Aug
  • Re: Running Totals?Peter Brawley3 Aug
    • Re: Running Totals?Barry Newton3 Aug
      • Re: Running Totals?Barry Newton5 Aug
  • Re: Running Totals?Brent Baisley3 Aug
Re: Running Totals?Barry Newton4 Aug