8 Replies Latest reply: Jul 24, 2015 2:28 PM by Sunny Talwar RSS

    How to find Best & Worst Customer By Sale ?

      Hello Deras.

      i want Find Best & Worst Customer By Sale.

      100.png

       

      i want Group by Per Customer And Calculate Sum (Total)

      -------------------------------------------------------------------------------------------------------------------------

      SumSale:

      Load customer,Sum(Saleamount) as SumSaleAmount

        Resident Sale

        Group By customer ;

      101.png

       

      But I can not find my first record and last record with customer. (Find Best And Worst)

      i want Show This Sample  by Text Object:

      D=>Best   =>720

      A=>Worst =>220