| Columns
|
Calculation
|
Description
|
| 1. Total Revenue
|
|
|
| 2. Total Bookings(Confirmed)
|
|
|
| 3. Total Direct Bookings(Confirmed)
|
|
|
| 4. Total Converted Booking(Confirmed)
|
|
|
| 5. Total Chargeable Weight
|
|
|
| 6. Top Customers By Revenue
|
|
|
| 7. Top Bookings (Confirmed) by Origin
|
Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by origin to compare side by side in a clustered bar chart.
|
This chart shows the total confirmed bookings for each origin location, making it easy to identify which origins generate the highest booking volumes and highlight performance differences across locations.
|
| 8. Top Bookings(Confirmed) by Destination
|
Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by destination to compare side by side in a clustered bar chart.
|
This chart shows the total confirmed bookings for each destination location, making it easy to identify which destinations receive the highest booking volumes and highlight performance differences across locations.
|
| 9. Top Bookings by Service
|
Counts only confirmed bookings and groups them by service type to compare in a clustered bar chart.
|
This chart highlights the total confirmed bookings for each service type, making it easy to see which services are most in demand and where performance differences exist across offerings.
|
| 10. Bookings by Weight Breaks Matrix Table
|
|
|
| 11.Conversion Rate by Month
|
|
|
| 12. Total Monthly Revenue
|
|
|
| 13. Total Chargeable Weight by Customer
|
|
|
