I have sales booking data for 3 years
I am trying to Analyze Increase or decrease in booking at customer Level based on the history, I mean current (2015) Fiscal Year; Fiscal
Month; Fiscal week; Vs Previous (2013/2014) Fiscal Year; Fiscal Month; Fiscal week
Whenever there is significant changes (increase or decrease) in booking behavior it should be highlighted.
If there is a holiday on particular day it should be highlighted (Holiday list for current year is available in the current spreadsheet)
I would like to show comparison between FY 2015 Vs FY 2014; FY 2013 at customer level and overall
e.g.: Average bookings - 2015: 10M
Comparison between Fiscal Week 50 2015 Vs Fiscal Week 50 2014; Fiscal Week 50 2013; at customer level and overall.
If I select a dropdown list or click a macro button the data should populate.
I tried using Pivot table and Slicers. But, stuck in between! Not able to show the comparisons accurately and not sure if we can show all the metrics using Excel. Hence it would of great help if you anyone could tell me which “tool” is best suit for these kind of analysis.
I have attached the file I am working on and looking forward for experts who can help me organizing the existing data, or helping me to create a model using Excel/ VBA script or any other tool which meets my exact needs.
Any suggestions would be greatly appreciated!
I am looking forward for the positive response!!!!!!