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:

      1.jpg

       

      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:

       

      2.jpg

       

       

      There's sample in the attachment.

      Thanks.