4 Replies Latest reply: Aug 30, 2013 1:32 AM by Ramkumar Ramagopalan RSS

    Need help with FirstSortedValue

    Ramkumar Ramagopalan

      =FirstSortedValue(distinct [Person],-[Sales])

       

      This expression returns the top sales person based on the Highest Sales value, but I want to retrieve the person with the highest Sum(Sales) value.

       

      e.g.

      Person Sales

      Rob    6000

      John   7000

      Rob    5000

      John   1000

       

      My expression returns John based on the highest sale 7000. Whereas I expect Rob to be returned because his sum is 11000. Please help.

       

      Thanks,

      Ram