Drill through waterfall chart

[violet11_6]

Hi.

I have a table as follows

Scenario	Currency	Year	Month	Org structure Lvl 2	Org structure Lvl 3	Org structure Lvl 4	Value
Actual
Budget

I had successfully built a waterfall chart that bridge the performance breakdown by [Org Structure Lvl 3] from Budget to Actual when filtering for the selected [Org Structure Lvl 2]. However, I would like to be able to drilldown by the related [Org Structure Lvl 3] to another waterfall chart that bridges the performance breakdown by [Org Structure Lvl 4].

I have tried selecting [Org Structure Lvl 3] as [Drill through] when building the detailed waterfall chart report. This, however, did not return the drillthrough feature that I was hoping to see when I returned to the main waterfall chart. 

Where could I have gone wrong? 

[violet11_6]

Hi. Since I'd selected [Values] as y-axis values in my first waterfall chart by [Org Structure Lvl 3] breakdown, I've also tried selecting [values] as the drillthrough field in the second detailed waterfall chart by [Org Structure Lvl 4] breakdown. It still did not work.

I tried using org structure hierarchy and it also did not work. Any kind soul able to advise where I've gone wrong?