3 Replies Latest reply on Jan 31, 2019 12:59 AM by SUJEET KULKARNI

    Current year and previous year sales


      Hello everyone,


      I have date, opening sales and closing sales.

      So whatever closing sales for previous date or month or year will be opening sales for next date or month or year.


      For eg. closing sales for Sept is 1000 then opening sales for Oct will be 1000 and so on.

      I have attached the excel sheet in the attachment for reference.


      I want the table in below format -



      DateThis year current month opening salesThis year current month closing salesPrevious year opening salesPrevious year closing sales


      So if i select October month,

      I want the "This year current month closing sales" from September to be automatically counted for  "This year current month opening sales" for october month.


      And same for Previous year as well.


      Please help me with this.


      Thanks in advance !