Drill-down using several data items and only one parameter

[mpholt]

Hi all,
I have spent a long time looking at this, and not sure if it is even possible. Any help you can provide is more than appreciated. What I am trying to do is, assuming I have a bar chart that displays values according to a data item A on the vertical axis, and the bar is divided up into segments according to values for any number of 6 data items. Assuming one data item is clicked on, I want the drill-down to pass the label of the bar segment that was clicked on to a parameter named "Category" that exists in another report.

For an example of the chart, see the attached 'chart.JPG.' The query that produces the value contains the 'Level' data item, and each series displayed in the legend (the bar segments) is another data item value.

The parameter "Category" that I am attempting to drill-down to will contain the name of each data item in the legend (Points Passed, Points Failed, Points Inconclusive, Points Not Started, Points Blocked, Points Attempted).

What I am trying to do is, when a user clicks a bar segment (for example the pink 'Failed' segment on the level TP3), the report should drill-down and pass the label "Points Failed" to the parameter "Category" (described above).
However, currently I do not know of any way to do this, as instead of having only one series in the bar, there is 6. There only exists one parameter that I am drilling-down to, so I am not sure how to pass the label of any of the clicked data items (ie, a segment), to the same parameter.

Any help that can be provided is greatly appreciated. Thanks!

[mpholt]

I apologize, it wouldn't allow me to upload the image.  Basically, the bar chart has a "level" data item on the vertical axis, and one of 6 data items as series that are displayed as segments of a horizontal bar by level.

[mpholt]

Does anyone have any ideas on this? Or any idea if it is not possible at all?

Thanks for any help you can provide,
  Matthew

[cschnu]

Is this label value a data item from your query? If so you can pass a dataitem value from your query with a drill-through.

[mpholt]

Is this label value a data item from your query? If so you can pass a dataitem value from your query with a drill-through.

Thanks for the reply. I actually meant to say in the description "Drill-Through" instead of "Drill-Down."  My apologies as it wasn't explained very well.  It wouldn't let me post attachments, but I have posted a better worded description of the problem with several screenshots at the below address:

https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14414995&#14414995

Any help you can provide is extremely appreciated.  Thanks!