3 Replies Latest reply: Dec 17, 2014 6:04 PM by Yap Ju Yau RSS

    How the expression sum the sales on max date ?

      hi ,

       

      I facing problem below:-

       

      sales transaction table

      salesperson, trx. date, trx amount

          May, 20141006, 10.00

          May, 20141006, 20.00

          Lee, 20141106, 20.00

          May, 20140906, 10.00

          Santa, 20141206, 30.00

          Lee, 20140106, 40.00

          May, 20140506, 10.00

       

      my expected result : -

      Sales person          Latest sales date         Amount

      May                        20141006                      30.00   

      Lee                         20141106                      20.00

      Santa                      20141206                      30.00

       

      How can get sum amount ? any idea ...