Sum Distinct rangesum over months

[madmax88]

Hi,

Following table:

Order ID	Date	Cust_ID	Customer_Stats
1	12.01.2019	22	activ
2	20.02.2019	22	activ
3	01.01.2019	23	activ
4	01.03.2019	24	activ
5	01.02.2019	24	activ

I need the distinct rangesum over time of the Customer_ID. I have following expression:

rangesum(above(Count({$<Customer_status={'activ'}>} Distinct(Cust_ID)),0,RowNo()))

This expression shows me if there are Sales in the specific month. If there are Sales in 2 Months i shows me 1 in the first month and in the second month 2 (accumulated), but I need only to know when the first sale happened and then ignore the following sales. Is this possible?

E.g. Cust_ID 22 has 2 Sales (Jan and Feb). Result should be "1" in Jan and 1 in Feb , because there is already a Sale in Jan.

[sunny_talwar]

Best way to do this is to use the The As-Of Table

[madmax88]

I know what you mean, but this is not the problem (I tried your solution). The Problem is still that a Customer is counted for each month where an Order ID exists.