Rolling 7 days

[Anonymous]

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                    

Date	Sales
Oct 1	5
Oct 2	10
Oct 3	8
Oct 4	9
Oct 5	7
Oct 6	5
Oct 7	6
Oct 8	4
Oct 9	2
Oct 10	34
Oct 11	1
Oct 12	2
Oct 13	3
Oct 14	4
Oct 15	4
Oct 16	5

Desired Result

Date	7 days sale
Oct 7	50 (sum of oct 1-7)
Oct 8	49 (oct 2-8)
Oct 9	41 (oct 3-9)
Oct 10	67 (oct 4-10)
Oct 11	59
Oct 12	54
Oct 13	52
Oct 14	50
Oct 15	50
Oct 16	53

[lironbaram]

hi

use this expression

rangesum(above(sum([Sales]),0,6))

[Anonymous · Accepted solution]

Hi

small change  in Liron Baram exression.

rangesum(above(sum([Sales]),0,7))