Variable Shift in Mapping

[#1]

Dear all,

I have a table of the following format

Reg_Month           Registration_Date               User     Days_to_Activation

Dec                       30.12.2012                         10          2

Dec                       31.12.2012                         20          1

Jan                        01.01.2013                         30          1

Jan                        31.01.2013                         30          2

Feb                        01.02.2013                         40          1

What I would like to calculate is a table that shows the number of activated user accounts per month. In this case the table should look like this:

Act_Month          Act_Date              #Accounts

Dec                    31.12.2012          10

Jan                     01.01.2013          20

Jan                     02.01.2013          30

Feb                     02.02.2013          70

Please could you help me how to design a script that provides such a table.

Thanks in advance

BR

qv_scrub

[tresesco]

Can you please elaborate the logic?

Thanks.