Disable first level of drill down

[NickHoff]

I'm going to try to explain this as best as possible.  The problem can be found at the very end. 

I have a drill through stacked bar chart with the dimensions CareLine and Initiative.  The expression of the stacked chart is SUM(Triggers), and Count(DISTINCT PersonID)   This chart drills down from the CareLine into the initiatives and is behaving correctly.

My second chart is the one that causes issues.  I had to create an inline table of %PTID, and PatientTriggers.  This table is created using:

PatientTrigger:

LOAD * INLINE [

    %PTID, %PatientTrigger

  1, Triggers

  2, Patients

];

Next the chart is built with two dimensions one being the hidden field %PatientTrigger, and the other using the drill through of the first chart CareLine and Initiative.  The expression of the stacked chart is:

PICK(%PTID,

SUM(Triggers),

COUNT({$<Careline=>}DISTINCT PersonID))

My charts works correctly when I click the first chart and my second chart drills down with it. As shown

However, if I click on the second chart the drill down goes into either Patients or Triggers and shows the same value as the first one instead of going down into the initiative.  As shown below, i'd like to disable the drill down on the first level of the second chart, and only have the drill down occur by clicking on the first chart:

[Gysbert_Wassenaar]

Perhaps you will have to use two separate drill-down groups for the two charts.

[NickHoff]

I wish it was that simple.  They are drilling down to the same level, but the pick function to make the chart possible has an additional drill that i'd like to exclude, but can't.

[jitenderkalouni]

is there any solution for this ?

[NickHoff]

Haven't found a solution, it was excepted as a feature and user training was required.

[balabhaskarqlik]

Did you resolved the issue, post the solution.