2 Replies Latest reply: Jul 22, 2013 11:54 AM by Surendra Masupalli RSS

    Help regarding Advanced aggregation

      Hi folks,

       

      I need small help regarding advanced aggregation.

      I've data like this.

      CountrySales PersonSales
      IndiaSurendra2000
      IndiaPawan1000
      IndiaSuresh5000
      USARamesh3000
      USAGirish20000
      USASurendra1890
      USAPawan5349
      UKKiran7890
      UKSuresh9890
      UKRamesh3234
      UKGirish5098

      All I want to show is the Sales Person who has done the maximum sales across each country.

      The result should look like this.

      CountrySales PersonSales
      IndiaSuresh5000
      USAGirish20000
      UKSuresh9890

       

      Kindly help me with the expression.

       

       

      Thanks,

      Surendra