drill-through feature in a pie chart

Hello,

Assume I have a pie chart report named as Report 1. This report breaks down a completion state column in the X table. Here is my question; I want to create another pie chart report names as Report 2, which breaks down the message column in the X table on the basis of a given completion state. In other words, Report 2 should be on the basis of a given completion state, via drill-through from Report 1. Thus, when I click the different slices of the pie chart of Report 1, I should get a separate pie chart report (i.e. Report 2), which breaks down the message column on the basis of a given completion state

Please let me know if you have any idea?

Sincerely,

--Amde

Report2 would need to use a parameterized data set query (to limit the dataset based on the provided parameter value for the completion state). The query parameter would be linked to a report parameter of report2.

Then, in report1, you define a drillthrough action on the chart datapoint to drill to report2 and specify the current completion state value as drillthrough parameter.

-- Robert

|||

Hi Robert,

I am clear with the first statement, however, I am not sure how to specify the current completion state value as drillthrough parameter.

what I did is I create an internal parameter for the completion state in the Report1 and pass it to the Report2 when I define a drillthrough action. But, this didn't work. When I click any of the slices of the pie chart from Report1, Report2 displays the same report all the time.

It would be very helpful if you tell me things I should do both in Report1 and Report2. A step-by-step procedure is very appreciable.

Sincerely,

Amde

|||

Now it is working.

Thank you for your assistance.

--Amde