Count

[#1]

Hi All,

can any one help me to get the expression to find the count,

I have a table like below , if a person has active Product sales less than 3000 for consecutive dates then count is 1 if not count is zero.

how to achieve this with set analysis.

        Edited: 

Expected Result is

A	2
B	1
C	1
D	1

Date	Active Productsales	Person
3/16/2013	1100	A
3/17/2013	2500	A
3/18/2013	2000	B
3/19/2013	2000	B
3/20/2013	2000	A
3/21/2013	3500	B
3/22/2013	2900	A
3/23/2013	2500	A
3/24/2013	2500	C
3/25/2013	2500	C
3/26/2013	3250	D
3/27/2013	2500	D
3/28/2013	2640	D
3/29/2013	2500	D
3/30/2013	6000	C
3/31/2013	4200	D

[#2]

Thanks Krishna,

it is not meeting my requirement. please find the above expected result.

[Peter_Cammaert]

Very easy to do in load script. It's a pity you don't want that.