nested Drill down

[Former Member]

Hi ALL,

i have a below senerio

1. pie chart with one year sales of different products.

2. Bar chart with one product sale for differnet countries while drill down from first chrt

3. third chart line chart need to drill from 2 nd chart with condition of first chart (product)

please help me put.

[faisal_altaf2 · Accepted solution]

Hi, Reddeppa

Can you Please Explain it bit more. What will be Drill Down Values from First Char the Input for the 2nd Bar Chart and than what you want to display from the 3rd Line Chart.

I think it is not very clear. will be very useful if you will display some sample data.

Kind Regards,

Faisal

[Former Member · Accepted solution]

hi ,

chart 1 (pie Chart): 2008 sales for P1, P2

p1 - 1000

p1 -2000

Chart2 (Bar Chart): while click P1 or P2

p1

America 200

India 500

china 300

chart 3 (Line chart) : while click on india of chart 2

jan 100

feb 100

march 100

.........

it should be dymic when i will click on P2 (Chart1)

i hope do u understand.

[former_member186358 · Accepted solution]

Reddeppa,

There are lot of ways to achieve this...simplest way is to create charts and display it dynamically.

Step 1: Create a Pie chart displaying P1 and P2 and their values

Select the Drill down option and have a destination row, so when user selects P1 that row will be copied to a destination row.

Step 2: Create a bar chart having America, India and China data

Select to display it Dynamically when user selects P1 (give value as P1 ) i.e. when user selects P1 it displays this bar chart....

similarly have another bar chart to display when user clicks on P2

Hope this helps...

-Anil

[Former Member · Accepted solution]

Hi Anil

thnx for reply..

actually i want drill down more than two levels

means to add answer if i want click on Bar chart which needs drill into another chart with another dimension

[Former Member]

Please help me out by giving solution for below query..