3 Replies Latest reply on Jul 26, 2012 5:35 AM by vaidaslauzeckas

    Combining Columns

    Robert Hoekstra

      Each of my records in a particular dataset has three different data elements for Country (1, 2, 3).  For a given record, anywhere from none to all three could be populated.

       

      I am attempting to map counts of how many times a country shows up.  If a single record had three different countries listed, the count for each country should increase by one.  The display is just going to be a simple map with the value of each count by country.

       

      For example, if I had:

       

      RecordCountry 1Country 2Country 3
      1USChinaAlbania
      2ChinaIndia
      3UK
      4ThailandIndia

       

      I should get a map with values on each country:

      China 2

      India 2

      US 1

      UK 1

      Albania 1

       

       

      How do I combine the three fields into a single reporting field?  And then how do I map it?

       

      Note, that I can get it to map for a single one of these measures just fine.  It just does a Count(Country1) and displays on a map that has level of detail set to Country1.

       

      But I need it counted for all three columns.

       

       

       

      Thank you.