7 Replies Latest reply: Sep 18, 2012 10:52 AM by jagan mohan rao appala RSS

    Help in Drill down of chart



          I was trying to create Drill down group for trend please find the excel sheet for dimension that i want include to groups and drill down.....


      1 level----International, Domestic, ABC, JKl


      if we click international and immediate next level is ABC,DEF,GHI  and if we cick ABC next level is CAD and xyz........etc as well as for domestic also


        i was trying below expression for 1st level but its not working


      =if(match(GROUP1,'International','Domestic'),GROUP1) and if(match(GROUP,'ABC','JkI'),GROUP)


      attached sample app also