6 Replies Latest reply: Oct 8, 2017 7:30 AM by Subash Dhakal RSS

    Dynamic 4 rolling quarter

    Subash Dhakal

      I have a Date1 column in this format - YYYYMM.

      Date1 = 201703 is 1st quarter

      Date1 = 201706 is 2nd quarter

      Date1 = 201709 is 3rd quarter

      Date1 = 201712 is 4th quarter

       

      Date1 = 201803 is 1st quarter

      Date1 = 201806 is 2nd quarter

      Date1 = 201809 is 3rd quarter

      Date1 = 201812 is 4th quarter

       

      How to create a rolling 4 quarter so that in a pivot table, the 4 quarters (as 4 columns) dynamically get updated?