8 Replies Latest reply: Apr 4, 2018 2:58 AM by BHARATH KUMAR RSS

    Aggr with FirstSortedValue

    BHARATH KUMAR

      I have a table:

      pic.JPG

      To get SUM(sales) group by Product I am using :  Aggr(Sum(Unitsales), Product)

      To get top most Product's Customers: FirstSortedValue(Customer, -Aggr(Sum(UnitSales), Product))


      I got result as "A.Astrida"

      Since top most Product AA is associated with 3 customers, on what basis I am getting "A.Astrida" ?

      Why not B.Astrida or Canutility ?

       

      Any help on this ??

       

      Thanks,

      Bharath