Not really. In that table are the real results, which you cannot sum at the end.
My table means:
I have from the product 23 at the start of week 13 1234 examples.
At the start of week 14 I have no visible moving from the start of week 13 to its end.
At the start of week 15 I have a purchase of 1224, although I have now 2458 examples.
And I want to show the difference between the start of week 13 an the start of week 14, ect.
You can say, that firstvalue of week 14 is the lastvalue of week 13.
Yeah, but I have already the information. WeekStart ist the first day of the week 00:00. That are the information above.
But you can say, that the WeekStart 00:00 is the same value like the WeekEnd 23:59.
Now I want to see the difference between the weekstarts. Can I do that with the information above?
The table above is the result of a daily table.
I add some more rows for one item, so that you can better understand:
%item, %week, date, stock
23, 13, 28.03., 0
23, 13, 31.03., 1234 (Purchase 1234)
23, 14, 05.04., 934 (Sale 300)
23, 14, 07.04., 1234 (purchase 300)
So at the WeekStart 13 I have 0, at the WeekEnd 13 = Weekstart 14 1234 => in the week 13, I have + 1234