I've got a large database that's got all our transactions and shipping costs from them, here's a simplified version:
Source Table
Date | ROUTE | Cost |
---|---|---|
01/20/21 | USA to UK | $40 |
01/01/21 | USA to UK | $40 |
01/10/21 | USA to UK | $40 |
12/20/20 | USA to UK | $30 |
11/20/20 | USA to UK | $20 |
11/20/20 | USA to UK | $20 |