2 Replies Latest reply on Aug 23, 2016 7:09 AM by Winson Lui

    Lookup the result of maximum amount of sum and the corresponding value

    Winson Lui

      HI,

       

      I would like to get the result of maximum of count and its corresponding value of a dataset.

      The format of the list is like this.

       

      RegionCountry
      Accound IDCount
      EuropeA111
      EuropeA121
      EuropeA131
      EuropeA141
      EuropeB211
      EuropeB221
      AsiaC311
      AsiaC321
      AsiaD411

       

      I would like to find out the region which has the larget amount of customers and the corresponding amount.

      Since the count no. is always 1, I believe it would be correct if we count the occurence of the region in the dataset.

      In the example, the outcome would be Europe and 6.

      Would you please tell me which formula I should use to get the result Europe?

       

      My final goal is to get a list of countries who are under the region with largest amount and their counta.

      In this case, it would be A, 4 and B,2.

      I hope the first solution can act like a filter which when I update the dataset, the results will change automatically.

      Thanks.