Forum Discussion

violet11_6's avatar
violet11_6
Frequent Visitor
3 years ago

Drill through waterfall chart

Hi.

 

I have a table as follows

ScenarioCurrencyYearMonthOrg structure Lvl 2Org structure Lvl 3Org structure Lvl 4Value
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? 

Need Help

1 Reply

  • violet11_6's avatar
    violet11_6
    Frequent Visitor
    3 years ago

    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?