1 Reply Latest reply on Nov 13, 2018 6:27 PM by Hari Ankem

    Grouping months to create rolling 3 months

    Manveen Dharni

      Hi,

       

      I am having difficulty grouping three months to create a rolling three months for a report. Below is the expected result.

       

      Dummy.PNG

       

      I am attaching a workbook with the test data. So essentially it is a 24 month rolling periods. It will shift to right every new month but months will stay at a range of 24 months from current month. So we are only looking at prior months from current month. As you can see current month is October 2018.

       

      I need to group three months at a time starting from prior month as you can see in the image above with the expected result.

       

      Any help will be greatly appreciated.

       

      thanks,

       

      MD