Forum Discussion
joshua1990
Post Prodigy
Post ProdigyRunning total with calculated column
Him all!
I have 3 tables:
tbl Article
| Article | Average Sales per week |
| A | 500 |
| B | 600 |
tbl Stock
| Article | Stock |
| A | 2000 |
| B | 6000 |
| C | 100 |
tbl Deliverys
| Article | Date | Delivery |
| A | 01.10.2022 | 500 |
| A | 05.11.2022 | 600 |
| B | 06.08.2022 | 500 |
| B | 08.10.2022 | 400 |
Now I would like to get a running total chart (weekly) that is starting today based on current stock level and then it summes up the Average sales and the deliveries per week. Past deliverys should be ignored.
How would you do that?
1 Reply
- Greg_Deckler
Community Champion
joshua1990 Not certain I am following 100%, what is the expected outcome (as in numbers that you would expect to see)
