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

    Sum 2 different nationalities

    benjamin raquin

      Hello,

       

      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 ?

       

      Example

                          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