Drill Down chart using a selector

[Former Member]

Hi ,

Is it possible to use the drill down option with a selector? I have figured out dirll down and it's quite simple but I can't seem to get it to work when a selector is in use

Here is my requirement

At the top layer it should show the region data when I click on any one region it should provide me the Bar chart (drill down chart)without Industries data in that particular region

and also I have 2 filters as selector

one filter is labeled as forecast and contains the values Current , Past & the other should be the Year contains the values 2007, 2008, 2009

I have a Region Pie chart which should default show the values Forecast = All and Year = All

if I select the values from the forecast = Current & select the values from year = 2006 the pie chart should display the values according to the selection and even the bar chart(drill down chart) should display the values according to the selection

Please any one let me know how can I do this

[Former Member · Accepted solution]

To make my question more simple

At the top layer (in the pie chart )we should have the Region data & when I click on any of the region the drill down chart (Bar chart ) should display the industries data for that particular region

I have selector as filter when I select the value the 2 charts should display the data according to the filtered values .

Please help me out

[former_member186358 · Accepted solution]

Sirisha,

Emailed you the xlf file as per your requirement...

Sirisha's Requirement:

Ultimately what we want is to have a selector (combo box) which will have the choices: person A, person B and person C. Then when a person is chosen, say person A, a pie chart will display amounts for info X, Y and Z that pertain to person A. Likewise, if we chose person B with the selector (combo box), the chart would change to the corresponding info X,Y and Z for person B. Once we have a particular person's data up we would like to then drill down on a slice of the X,Y,Z pie and display the subcategories of information on a neighboring column chart. So, we have person A up, we then see their pie of X,Y and Z, now we click on the Z slice and we would like to see a chart with the detailed info for Z: Zsub1, Zsub2 and Zsub3.

-Anil