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

    Help in Drill down of chart

      Hi,

       

          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