Trucks and Units per truck

[rubin718]

Hello,

Our warehouse ships out a full truckload every day and in each truckload, we will have x amount of units. I want to create a spreadsheet that will keep track of how many trucks we are doing per week and units and give me a nice breakdown of how well we are doing per week, month, quarter, and year. Just an overall growth metric of trucks and units shipped. This is what I have so far and I need this in google sheets.

The format doesn't need to look like this, just not sure what is the best way to format it.

Thank you for any assistance you can provide.

 

[ranman256]

1. the best way would be to use Access database.
if not,
2. post all data into the same sheet, the same columns A,B,C. (not like you have shown.) because then analysis is easy this way via pivot or graph.
different weeks on different rows, but still in ABC.