WINDOW_SUM(COUNTD(IF [status]='REPEAT' THEN [Account] END))
WINDOW_SUM(COUNTD(IF [status]='LAPSED' THEN [Account] END))
Hope it helps.
I created this Calc but I am not aware where you want to See it. So place it wherever Status you weant it to be.
If it Helps, Pl mark it Helpful and Correct to Close thread
example3_v10.3.twbx 50.2 KB
thanks for your help deepak