Comulative count

[oumaima2]

Hello Qlik Community, 

I am trying to calculate in the last line of this pivot table the count of a  field for  each month , but i want it to be cumulative for example in March we have 3 i want it to be 5 instead of 3 which is 2+3 value of February and march I have tried in a KPI it's working fine but when I use a pivot table it doesn't work .

this is my fomula for the KPI 

count({<MonthAcc= {"<=$(= max(MonthAcc))"},YearAcc= {"<=$(= max(YearAcc))"},Claim_Status_CF={'Open','Re-Open'},ENTITY_CF={'CEG'}>} DISTINCT If(IsNull(UCR_CF),CLMREF_CF,UCR_CF))

[oumaima2]

I hope someone can help with this

[Harsha-Lodha]

Hello @oumaima2  I am also facing the same issue. I am trying to build table which has org_nm, svc_year, month_num_in_svc_year, engaged_people count upto that month_num_in_svc_year. this below formula works fine for KPI Aggr(
Count(DISTINCT IF(month_in_svc_year_num <= month_in_svc_year_num, fam_assisted)),
org_nm,
svc_year,
month_in_svc_year_num
) but doesn't work for table where other dimensions in table are org_nm, svc_year, month_in_svc_year_num. date island is one approach but it doesn't work well for large datasets. Please let me know if you find some simple solution. also if @qlik @qlikqlik comes up with some easy way to do conditional aggregations for row level data. thank you