Add interactive /drilldown/drillthrough/zoom in

Drilldown: When clicking on a certain data point in an aggregated table or a chart I want to be able to view more granular data. Eg. Total transaction by chain drilldown to transactions by account for selected chain drilldown to individual transaction records for selected account. Zoom in: is about time granularity. Viewing transactions by month I want to zoom in to transactions by week by day by hour and finally to individual transaction records.