2 Replies Latest reply on Feb 12, 2018 12:19 AM by Rajesh L M

    conditional filter

    Rajesh L M

      Hi All,

       

      i have a below requirement and i want show it as a single filter

       

      IF Sales<100000 then 'less then 10'

      IF Sales<200000 then 'less then 20'

      ELSE 'ALL'

       

      when i select "less then 10", i want to see all the subcatagories which is less then 100000

      when i select "less then 20", i want to see all the subcatagories which is less then 200000

      when i select "ALL", i want to see all the subcatagories

       

      i have attached the twbx file

       

      Thanks,

      Rajesh L M