1 Reply Latest reply on Apr 10, 2018 11:12 PM by Meghanath Singh

    Conditional 6 monthly Running Sum of monthly count of patients

    Meghanath Singh

      I need to show a calculated measure named 'To Be Treated' which is a running sum of monthly count of patients as below -

      Jan-17Feb-17Mar-17
      Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17
      Nov-17
      Dec-17Jan-18Feb-18Mar-18Apr-18
      Count of Patients2134203204250231
      To be Treated1313171924
      2426

      The treatment of patients is seasonal and happens only between Sep to Mar. 'To Be Treated' for Sep-17 will be sum of patients for 6 months from Feb-17 to Jul-17, for Oct-17 will be sum of patients from Mar-17 to Aug-17 and so on.