How to count aggregation including previous years

[rvijayanth]

My data is like this: 

ID	Year
A	2016
B	2016
C	2016
D	2017
E	2017
F	2018
G	2018
H	2018
I	2018
J	2019

I am looking to get count like shown below: 

Year	Count of ID as of Year
2016	3
2017	5
2018	9
2019	10

As of year 2016, the count should be 3. 2017 should include 2016 and 2017. 2018 should include 2016, 2017 and 2018 and so on and so forth. The final year should be a summation of all counts.

I also like the same if I chose to view Month or Quarter instead of Year as a dimension. Please help

[Channa · Accepted solution]

it will work

RangeSum(Above(Count(Year), 0, RowNo()))

[rvijayanth]

Thanks. How do we add set analysis to it, lets say I want to add {<Sex = {'Male'}>}. Where should I add?

[rvijayanth]

It works now. Thanks for the reply.