2 Replies Latest reply: May 9, 2017 8:28 AM by ruud kamp RSS

    Quaterly Cut-Off date report

    ruud kamp

       

      Hi,

      I need to allocate historical value’s to a quarterly cut-off date report. When an amount is changed,  I have record  with DateChanged and the new Amount . My Input data looks like:

           

      EmployeeIDExpenseTypeDateChangedAmount
      ASalary01-01-16500
      ASalary15-04-16550
      ASalary01-01-17575
      ATravel01-01-1610
      ATravel15-05-160
      ATravel01-01-1715
      BSalary01-02-16390
      BSalary01-01-17410
      BTravel01-02-1617
      BTravel01-01-1719

       

      The report I need is:  

      EmployeeIDExpenseType01-01-1601-04-1601-07-1601-10-1601-01-17
      ASalary          500           500           550           550           575
      ATravel            10             10              -                -               15
      BSalary             -             390           390           390           410
      BTravel             -               17             17             17             19

       

         

      Who can help me?

      The Excel model is attached - Ruud Kamp