• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dashboard: Travel Bookings done through different channels

jayexcel1

Member
Hi,

There is a Travel company which sells two types of packages; say PackageA and PackageB. The company sells it through different channels across different cities:
  1. Company owned Big Shops (BigShop)
  2. Company owned Small shops (SmallShop)
  3. Third Party vendors (ThirdParty)
Three reports are extracted which shows the number of bookings for PackageA and PackageB made at the above 3 different channels through the year; Jan till Dec 2015.

I want to show for both PackageA and PackageB:
  • The total bookings done through each of the 3 channels for any particular month or till year end.
  • The respective percentages of the above total with respect to the 3 channels.
2.
  • The total bookings done in any particular city at each of the 3 channels for any particular month or till year end.
  • The respective percentages of the above total with respect to the 3 channels.
In addition, I want to show every time the above data for the current month(say January) as well as the next upcoming month(February).

Would appreciate any help regarding this.

jay
 

Attachments

  • Sample Data Package.xlsx
    475.4 KB · Views: 8
Hi Jay,

I am bit confused by when you say
  • The total bookings done through each of the 3 channels for any particular month or till year end.

What do you mean by till year end ? Is it mean the whole 2015 year is already booked in 2014 only, or the data will updated on monthly basis & you want YTD data?

Can you explain this part.

Regards,
 
Hi Somendra,
The bookings will be done in advance; and the booking calendar is open till Dec 31st 2015. So, there will be some data for the months Jan till Dec.
The total bookings done through each of the 3 channels for any particular month or till year end.
By "till year end", I mean the total bookings for 2015 (Jan till Dec) as of now for respective Packages through each of the 3 channels.

Hope I'm able to clarify your point.

jay
 
Hi Somendra,
Many thanks for your time and effort.
This is fine with me except that the numbers returned are "Counts" instead of "Sum".
The "Count" works fine with "Rept - PackageA&B Channel 2" i.e. SmallShop.

But for other two channels, it should return the sum of values of the Bookings column.

jay.
 
Hi Somendra,
This works perfectly.

Just to add-on to it, If I want to show the percentage contribution of each channel for PackageA graphically based on the cells D2 & D3; how should I go about it. Same for PackageB.

jay.
 
Back
Top