Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it will work
RangeSum(Above(Count(Year), 0, RowNo()))
Thanks. How do we add set analysis to it, lets say I want to add {<Sex = {'Male'}>}. Where should I add?
It works now. Thanks for the reply.