Count

[#1]

Hi All,

I Need to generate active employees count with in the period start date and period end date

like  i have one year data with me and i divided that year into 26 periods

now i would like to generate Active employees count with in each period start date to period end date based on another generated field date.

P1--->  1/1/2015 to 1/14/2015------>6

P2---->     1/15/2015 to 1/28/2015-----> 8

P3----->    1/22/2015 to 2/12/2015---->10

Regards

John