We have tried that approach, but to group the data by their booking and travel dates would exponentially increase the data volumes to the point that excel cannot handle.
Viewing the data by booking and travel dates would make each line item almost unique.
We have also tried it by weeks on the travel date – it can handle the volume, but the tool becomes very sluggish.
Can I further understand what’s the objective of drilldowns to such granular level?