2 Replies Latest reply: Oct 18, 2018 2:52 AM by aruna dabba RSS

    Rolling 7 days

    Isabel Encinas

      Hi Experts,

       

      Would like to seek advise on how to write correct set analysis with this situation.

      I have # Sales per day.

      The results I want is the sum of the running 7 day sales

       

      Sample Data                    

      DateSales

      Oct 1

      5
      Oct 210
      Oct 38
      Oct 49
      Oct 57
      Oct 65
      Oct 76
      Oct 84
      Oct 92
      Oct 1034
      Oct 111
      Oct 122
      Oct 133
      Oct 144
      Oct 154
      Oct 165

       

      Desired Result

      Date7 days sale
      Oct 750 (sum of oct 1-7)
      Oct 849 (oct 2-8)
      Oct 941 (oct 3-9)
      Oct 1067 (oct 4-10)
      Oct 1159
      Oct 1254
      Oct 1352
      Oct 1450
      Oct 1550
      Oct 1653