11 Replies Latest reply: Jul 11, 2013 5:19 AM by Thomas Jensen RSS

    Filter listbox values

      Hello

       

      How do you filter listbox values?

       

      Eg:

       

      I have a listbox containing customers.

       

       

      Lets say i have from A to Z customers:

       

      A

      B

      C

      D

      E

      F

      G

       

      and so on.

       

      But in my charts there is only data for A,B,D.

       

      So i want my listbox only to show A,B,D and not all the others because they dont have any data on them.

       

      I would think something like this, but it is not working:

       

      =if(sum({$<"[DimCustomer].CustomerName"=>} "[FactQVTimeRegistered].TimeRegistered") >0,"[DimCustomer].CustomerName", null())