Hi,
I am looking for a macro which helps me create a pivot table with Rows as Truck Arrival Timing in Hours with 1 hour interval, Destination in Columns, Sum of Chargeable Weights as Values. The Chargeable weight needs to be sorted in Descending order indicating that which time period there will be a volume peak.
In the Raw Data file, I want to add 1 more column next to Flight Arrival Time as Truck Arrival Timing.
Truck Arrival Timing must be calculated as an additional column in the Raw Data file.
The Truck Arrival Timing column need to be filled based on the Service level column if the Service Level is SL1, then need to add 6 hours with the Flight Arrival Timing,
If the Service Level is SL2 or SL3, then need to add 8 hours with the Flight Arrival Timing.
The above mentioned column must be used as Row in the Pivot table.
Please assist to help.
Bookmarks