8 Replies Latest reply on Feb 22, 2018 6:08 PM by t.c.4

    sum of the last x no. of months

    t.c.4

      sample.PNG

      Hi, I was trying to sum up the "yes" and "no" separately for the past 6 months.  I've tried using window_sum to total the last 6 rows. But I want 6 months' worth of "yes" and 6 months' of "No".  it's not predictable because sometimes either Yes" or "No" is not there.  Eg July 2017 has a "Yes" but "no" is missing.

       

      Does anyone have any tip?

       

      Thanks, Sea Urchin