3 Replies Latest reply: Dec 24, 2013 4:57 AM by Sravanthi Jakkapuram RSS

    Dynamic Filter issue

      What I'm trying to do is create a dynamic filter2 where filter1 is created as Type ={A,B,C} as values using inline table...


      Suppose if I select Type as A.....Only {A,B,C} possible values should be available in next filter(Currently im seeing all values)

      Ex1: Filter1 ....A

              Filter2 ....{A,B,C}


      Ex2: Filter1 ....B

           Filter2 ....{1,2,3}


      Please suggest...Expression used for Filter 2

       

      Filter2 =if(Type ='A',[Column A],if(Type= 'B',,[Column B],[Column C]))


      Data is shown below

       

      Column AColumn BColumn C
      A1Y
      A2Y
      A3Y
      A4Y
      A5N
      A6N
      B1Y
      B2Y
      B3Y
      B4Y
      B5N
      B6N
      C1Y
      C2Y
      C3Y
      C4Y
      C5N
      C6N