8 Replies Latest reply: Jun 13, 2018 1:29 PM by shivesh singh RSS

    Aggregation with latest transaction.

    Ganesh Reddy

      Hi All,

       

      How to achieve the second table, I need to show both in the dashboard.

       

       

      T Number

      Date

      m1

      m2

      0003 CM 1

      17/08/2015

      0

      0

      4 CM 1

      22/01/2016

      0

      0

      5 CM 1

      19/02/2016

      0

      3,502

      6 CM 1

      19/07/2016

      0

      3,809

      7 CM 1

      19/09/2016

      0

      5,350

      8 CM 1

      04/10/2016

      0

      5,694

      9 CM 1

      19/10/2016

      0

      5,694

      10 CM 1

      09/01/2017

      0

      5,690

      11 CM 1

      20/01/2017

      0

      86,687

      12 CM 1

      28/03/2017

      0

      8,605

      13 CM 1

      18/05/2017

      0

      8,219

      14 CM 1

      15/06/2017

      0

      3,908

       

       

       

       

       

       

      Team

      Tra Reference

      Group Name

      Status

      Amount (Latest m1 +m2 from first table)

      Pro Zen

      30732AB

      JRB

      OPEN

      3,908

       

       

       

      Thanks,

      Ganesh