Count Missing ID

[pooja_prabhu_n]

Hi All,

I am facing difficulty in building the logic mentioned below:

If a ID was activated and never deactivated till Today then consider it as active for all Months.

Input:

output:

In the above output:

Jul 2012 had 2 IDs 1 and 2 ,therefore  Count(ID)=2

Aug 2012 have only one ID(i.e. 2).  ID 1 is not updated in Aug  and also it is not deactivated in Jul 2012 .So,i have to count it as activate in Aug 2012 .

Thanks,

Pooja

[Digvijay_Singh]

If possible please share the sample data which can be used to produced the required expression easily.