2 Replies Latest reply: Oct 20, 2017 8:06 AM by Андрей Шепель RSS

    Insert peek values

    Андрей Шепель

      Colleagues, good day!
      Would be glad to get some advise to solve this task:


      I have simple table with following structure:



      i need to insert to this table several records (per each month) with this condition:
      id - get previous id value

      date - get monthend value

      sales1 - get previous value

      Sales2 - get previous value


      so the result should be the following:





      There's sample in the attachment.