6 Replies Latest reply: Feb 5, 2013 11:51 AM by luizfereis RSS

    Listbox filter

      Hello,

       

      My data looks like that:

       

       

      FieldAFieldB
      XA
      XB
      XC
      YA
      YB

       

      I want to create a listbox that shows only FieldB for FieldA = Y.

       

      I can do that easily with =if(FieldA=Y,FieldB) but I have 4 listboxs that work this way in my dashboard and that is resulting in a perfomance loss.

       

      I think there is a way to do that with some aggregation function, but I just dont know how to do it.

       

      Thanks for any help!

       

      Att,

       

      Luiz Fernando