drill down on bar chart

[cognos05]

Hi,

I have a requirement to show bar chart with total sales for rolling 12 months .

And once the sales is shown, user will have the capability to drill down .

On drill down on any month , it should take that month as an input and show the sales by product teams for that month drilled.

Can you tell me how to achieve the drill part .

Also when they drill , first it should show sales by product team for that month and then again on drill down on any product team should take to product line level and then on product line drill down should show a table with product details.


Any suggestions on the right way to proceed is really appreciated.

Thanks,
Nithya