Totals Month to Month

[Rnc2005]

Below is an excel spreadsheet displaying the total number of users from MTM (57,642...). I'm having an issue getting that column to populate in Qlik Sense. 

Excel Total Number of Users MTM

Here's what I am able to create which is the number of users for that month but not a rolling MTM. 

 Qlik Sense Users Created MTM

 Thank you in advance! 

[sunny_talwar]

Assuming your expression for User Count is Count(User), try this

RangeSum(Below(Count(User), 0, RowNo()))

[Rnc2005]

Thank you for the quick response. 

The formula's adding MTM: Nov & Dec providing a total of 679  but I was hoping to see the totals in the second screenshot:

[sunny_talwar · Accepted solution]

How about this

RangeSum(
   Count(TOTAL User),
   -RangeSum(Above(Count(User), 1, RowNo()))
)

[Rnc2005]

That did it 🙂 

Thank you so much, I appreciate the help!!!