6 Replies Latest reply: Dec 3, 2015 11:48 AM by Kenny Lin RSS

    Need help with Max date and sum set expression

    Kenny Lin

      Name:            Sale Date             QTY

      X                   10/01/15                  5

      X                   11/01/15                 10

      X                   12/01/15                 15

      Y                   10/01/15                  5

      Y                   11/01/15                 10

      Y                   12/01/15                 15

       

      How do I get to a set expression of below result:

       

      Name:            Max Date of Sale Date             Total QTY

      X                   12/01/15                                       30

      Y                   12/01/15                                       30