6 Replies Latest reply on Nov 7, 2012 11:23 AM by A O

    AND operation using check boxes

    A O


      i got stuck for a while so figured I'll ask. Is it possible to have checkboxes perform AND function. For example, I have two columns. First column has student's name, second column has courses s/he took. For example:


      John  Chemistry

      John  Physics

      John  Biology

      Kate  Chemistry

      Kate  Physics

      Monica Biology


      I am trying to filter out students who have taken Chemistry AND Physics (John). The way my checkboxes currently filter data appears to be based on the Chemistry OR Physics rule (John and Kate).


      Thanks in advance!