Hi team,
Best way to calculate "sales" for current Week, Last week, -2 weeks...and so on? Considering weeks starts on Monday. I have read many about, but withouth a clear idea of how to do.
A table as example.
| DATE | DAY | WEEKNUM | SALES |
| 26/12/2020 | sรก | 52 | 140 โฌ |
| 27/12/2020 | do | 52 | 150 โฌ |
| 28/12/2020 | lu | 53 | 160 โฌ |
| 29/12/2020 | ma | 53 | 170 โฌ |
| 30/12/2020 | mi | 53 | 180 โฌ |
| 31/12/2020 | ju | 53 | 190 โฌ |
| 01/01/2021 | vi | 1 | 200 โฌ |
| 02/01/2021 | sรก | 1 | 210 โฌ |
| 03/01/2021 | do | 1 | 220 โฌ |
| 04/01/2021 | lu | 2 | 230 โฌ |
| 05/01/2021 | ma | 2 | 240 โฌ |
| 06/01/2021 | mi | 2 | 250 โฌ |
| 07/01/2021 | ju | 2 | 260 โฌ |
| 08/01/2021 | vi | 2 | 270 โฌ |
| 09/01/2021 | sรก | 2 | 280 โฌ |
| 10/01/2021 | do | 2 | 290 โฌ |
| 11/01/2021 | lu | 3 | 300 โฌ |
| 12/01/2021 | ma | 3 | 310 โฌ |
| | | | |
| | | | |
| | sales current week | 3 | 610 โฌ |
| | sales last week | 2 | 1.820 โฌ |
| | sales -2 week | 1 | 630 โฌ |
| | sales-3 week | 53 | 700 โฌ |
I really apreciate for help!
