4 Replies Latest reply: Oct 12, 2017 4:28 PM by Suraj Kumar RSS


    Suraj Kumar

      Hi All,


      I want to create a field or a front end expression to filter rows in Status field.

      The user should have 2 values to choose- Top, All.


      When All is selected, show all products. If Top is selected show only products with status Yes.



      LOAD * INLINE [

          Product, Status

          A, YES

          A, YES

          B, YES

          C, NO

          D, NO



      I created this filter but it is not working

      if(Status = 'YES' or Status = 'NO','All',

      if(Status = 'YES','Top'))

      Please help.