Hi everyone
I am trying to calculate historical fleet develoment, but is facing som troubles. It is a simplified example, .
I have the following data set:
| Car id | | Delivery date | | Size deadweighton |
| 1 | | May 2, 2020 | | 1 |
| 2 | | May 2, 2020 | | 1,5 |
| 3 | | July 1, 2020 | | 1 |
| 4 | | December 1, 2020 | | 2 |
Which I can summarize to see deadweighton released in a given quarter:
| Quarter | | Delivered car deadweighton |
| 2020 Q2 | | 2,5 |
| 2020 Q3 | | 1 |
| 2020 Q4 | | 2 |
| Total | | 5,5 |
What I need is to be able to calculate the historical car fleet development backwards like this, so that I can see the fleet size in a given quarter:
| Quarter | | Car fleet size | | Calculation behind |
| 2020 Q2 | | 2,5 = (3,5 -1) | | = Car fleet size 2020 Q3 minus delivered deadweighton 2020 Q2 |
| 2020 Q3 | | 3,5 = (4,5 -2) | | = Car fleet size 2020 Q4 minus delivered deadweighton 2020 Q3 |
| 2020 Q4 | | 5,5 = (total in previous table) | | = Total car fleet size as per 2020 Q4 a.k.a. the total of the delieries from previous table |
All help or tips are very welcome and would be a great help.
Sincerely, Signe
