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



      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