1 Reply Latest reply on Aug 23, 2016 1:07 PM by Benjamin Greene

    CountD with IF

    Ricardo Smith

      Hello all,

       

       

      In Table 1 below we have a list of cities and the clients who visit these cities. I am trying to develop a table similar to the one shown in Table 2, this shows the number of clients who visit each city as a percent of the number of unique clients.

       

      Table 1

         

      CityClientIDRecords
      Kingston24-221
      Kingston24-231
      Kingston24-241
      Kingston24-1051
      Bridgetown24-1051
      Bridgetown24-1071
      Port of Spain24-371
      Port of Spain24-1051
      Port of Spain24-221
      Port of Spain24-401
      Port of Spain24-431
      Port of Spain24-411
      Port of Spain24-441
      Havana24-451
      Melbourne24-1051
      Melbourne24-471
      Melbourne24-481

       

       

       

      Table 2

       

      CityCountPercent
      Kingston4                   
        30.77
      Bridgetown2                   
        15.38
      Port of Spain7                   
        53.85
      Havana1                      
        7.69
      Melbourne3                   
        23.08
      Unique Clients13100.00