2 Replies Latest reply on May 14, 2015 12:33 PM by Ryan Sparks

    rolling quarter

    john.stjohn


      Hello, I have a simple data set.  I work in HR and we have a monthly average headcount.  Our summary dashboard has the monthly totals for the last 12 months with the new value added for each month.  There is a summary worksheet on the same page with quarters.  I would like to have a rolling quarter.  For example, the current month we have for 2015 that has been completed with an average monthly headcount total is February.  I would like the summary page to have rolling quarters rather than actual quarters.  So the most recentmonthly quarter would be Feb-Jan-Dec  then behind it would be Nov-Oct-Sept

       

      Next month we would have the rolling quarter of Mar-Feb-Jan then behind it is Dec-Nov-Sept

       

      each month I would want to roll the quarter forward by a month.

       

      Thanks for any suggestions.

       

      jsj