The sum of sales for 7 days from the date in the table

[PapaJapa]

Hello.

I have simple table with dates and sales (~50 rows with unique dates):

Date | sum(Sales)

I would like to add third column with sales  for the previous 7 days before date in row.

Please help 

M

[HugoRomeira_PT]

Hello,

This can be achieved using the following expression:

RangeSum( Above(total sum(Sales),0,7) )

Remark:

The Above() expression is assuming that you want to have your table sorted by date in Ascending order (oldest date will be the first date on the table).

In case you want to change the sort Descending (Recent dates comes first) you need to replace the Above() by Below() expression.

Hope it helps!