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

    Need help with FirstSortedValue

      =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.



      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.