Rangecount() help needed

[#1]

Dear All,

I'm trying to create a rangecount() expression that will count number of appearances up to a given column e.g. (see the attached tables) if John appears once he gets 1 in Apr; Peter, on the other hand, appears 3 times thus he gets 1,2 and 3 in Feb, Mar and Apr respectively.

Could you please give a hint how to create such a counter?

BR,

Przemek

[#2 · Accepted solution]

Hi,

Please see the attached qvw. I have taken your sample data and had a workaround to modify the expression.

Thanks & Best Regards

Kuldeep Tak

[#3]

Thank you, Kuldeep. Would you yet know how to modify the expression to:

1) get zeros in months where Name doesn't appear

2) get totals right if you add years to data.

as it is done in the attached file.

BR, Przemek