Mothly Count

[Sameer9585]

Hi,

I have a dataset which is having ID,Termination and Resignation and now I need the count of ID who have applied for resignation month wise and next is that I need to create an other measure in such a way that I need the cumulative difference from complete count of ID monthly.

Ex: If total 10 are there and 2 left on Jan I need Count as 8,if 3 left on feb I need count as 8-3=5 so on..

Below I provide the data set I am using in it Sheet 3 is to be focused.

Thanks,

[Sameer9585]

I have one doubt why the count(ID) is cumulative?
Can we do without accumulation?
I need in that

[Vegar]

Count(ID) is a acumulative over the As of dimension not the regular month
dimension.

Please take a look at the As of-Table blog post by @hic
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

[Sameer9585]

Yeah, I got that I don't need that accumaltion