Excel Report

We have a platform to do pickups and deliveries but now I'm being requested to do a report for the Regional Station on how much we could've saved if some of those pickups or deliveries were consolidated. Ex. If we had two shipments for the same customer one day but we arranged the pickup separately instead of together. They want to know how much money we could have saved from YTD. I'm not sure how to better explain... I tried to do a PIVOT but I got stuck and not sure how to continue. Im attaching only one station but I need to do it for other 5 so if anyone could help me to explain how to do it I will be more than happy. thank you.