Help with Accumulation of New Distinct Daily Values

[datagrrl]

In this example User 4 should count on Day 1, User 1 on day 2, User 2 and 5 on day 3 and user 3 on day 4. 

I would prefer this to accumulate for each month. At the end of the month the total should be the total # of distinct NEW users (Not the total of distinct daily users, that would be too high)

Date	NewUsers	CummNewUsers
1/1/2020	1	1
1/2/2020	1	2
1/3/2020	2	4
1/4/2020	1	5
1/5/2020	0	5

I am attaching my dummy data and my example. Any help is appreciated. I am hitting a wall on this one.

[sunny_talwar · Accepted solution]

Try this

RangeSum(Above(Sum(Aggr(If(UserID <> Above(TOTAL UserID), 1, 0), UserID, (Date, (NUMERIC)))), 0, RowNo()))

[datagrrl]

Thanks so much. I thought Rangesum might get me there, but I wasn't setting it up correctly.