Skip to Content
author's profile photo Former Member
Former Member

Drill Down chart using a selector

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 03:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.