Drill Down on Charts should also display a chart.

[nag999]

Hi Dudes,

I had a specific problem. Instead of having drill down on records i want the drill down as below

Firstly I will display the THE SALES AMOUNT and MONTHLY wise records as below. on drill down it should be showing the chart which shows sales agianst different Areas for that month. On further drill down on Area wise we will show the products drill down sales.The important thing to notice is expect monthly listing all others are charts which appear on drill down.

First Listing will like below.
Month/year $ Sales
----------------------------------
Mar-2000 200,000
Apr-2000 195,000
May-2000 172,000
June-2000 150,000

On Further Drill Down We will show a bar chart where x-axis show Shipping Area and y-axis show Total sales area wise for each month.There should also be a drill down which which drill down further in to other chart for each shipping area, In that chart we have x-axis as products and y-axis as Total sales.

I want to know whether we can create drilldown as charts for each group we drill down.

Any help is really appreciated.

With Regards
Nagaraj(ART)