Cumulative Count in Bar Chart

[dwertz]

I'm currently showing the count of new users in a given account creation YearMonth dimension. I need to show a cumulative count of users at the end of each of these months. Does anyone know a formula that will allow me to do this? I'm including a pair of screenshots as well to try and make my question clearer. The top is where I'm currently at, and the bottom is the sheet I'm trying to reproduce using raw data (rather than a processed data excel file that I used to create the bottom sheet).

Right now my dimension is YearMonth and I'm doing a simple count(Username) and count(Admin) as my measures.

Any advice would be appreciated as I'm still learning to use Qlik.

[Andrew_Incite · Accepted solution]

You should be able to do a range sum, which looks at the row and the row above it continuously for every dimension value. 

RangeSum (above(count(Username),0,RowNo()))

RangeSum (above(count(Admin),0,RowNo()))

[dwertz]

This worked perfectly. Thanks.

[dwforest]

So you have an account created record based on a date? Hard to guess without the raw data.
If you hook up a calendar it will allow to easily aggregate by any dimension in the calendar, e.g. Month, Week, Quarter.
You could also MonthName(Date) your data and use that.

[paul_hooper]

Thank you! I've been searching for a simple way of doing this for what feels like a significant fraction of eternity, and this solution works perfectly!