5 Replies Latest reply: Mar 17, 2016 10:55 AM by Gysbert Wassenaar RSS

    Looping between months

    Stella Patrizio

      Hi,

      I have the sales of 10 stores saved in a table for every month; in other words, in table Sales1601 there are the sales that the 10 stores made in January '16, in table Sales1602 there are the sales that the 10 stores made in February '16, in table Sales1501 there are the sales that the 10 stores made in January '15 exc.

       

      I'd like to have a script that's able to read the current month(Ex: March) and load all the data referring to the previous months (February and January), for the current year and also for the previous year.

       

      Someone knows how to do it?

       

      Thanks.