5 Replies Latest reply: Nov 7, 2016 3:53 PM by Marco Wedel RSS

    Presenting The Changed Salary - New & Old Value

    Ibrahim Qaed

      Dears,

       

      I hope you are doing well,

       

      I am now developing a new report for HR Manager and one of the his request that he needs to see all salary changes happen for all employees in certain format.

       

      The data structure like this:

         

      Emp NameAmountStart Date
      Jolly15002012-02-21
      Jolly17002016-10-01
      Sergo30002013-09-01
      Sergo32502014-07-15
      Sergo37002015-05-01
      Sergo40002016-09-20
      Sara9002015-07-29
      Sara10002016-02-01
      Sara12002016-03-01
      Jon16002016-09-01

       

       

      and I want to present it like this:

       

      Emp NameOld AmountNew AmountLast Change
      Jolly150017002016-10-01
      Sergo300032502014-07-15
      Sergo325037002015-05-01
      Sergo370040002016-09-20
      Sara90010002016-02-01
      Sara100012002016-03-01
      Jon160002016-09-01

       

       

      Can anyone tell me how can I make this table.

       

      Appreciate your support,

       

      Thanks,