2 Replies Latest reply: Jun 12, 2017 4:38 AM by benjamin raquin RSS

    Sum 2 different nationalities

    benjamin raquin



      For my first message on this forum I would like to ask a question regarding calculation on nationalities.

      My observations can have 2 different nationalities stored in two variables (Nat1 and Nat 2)


      My question is how can I observe one nationality simultaneously on those 2 variables ?



                          Nat1      Nat2

      customer 1:      US     CA

      customer 2:      CA     N/A

      customer 3:     DE     US


      With the list above I need to be able to count 2US , 2 CA and one DE

      Is it also possible to only have one selection option in the filter ?


      Thanks in advance