4 Replies Latest reply on Oct 2, 2018 8:28 AM by Jim Dehner

    Need help with finding the top 1 user/Salesman from each category/region

    Sonnie Chen

      Hi,

       

      I need help with finding the top 1 Salesman from each region.

       

      My sample data looks like below

       

       

      Below is format of the output, I am seeking

       

      I have attached the sample data here.

       

      Some important points to consider here:

       

      • There could be thousands of salesmen
      • Each salesman can have sales in multiple regions, and it is possible that one sales man be the top 1 in multiple regions