4 Replies Latest reply on Sep 8, 2013 12:52 AM by Steve Martin

    Duplicate time periods between parameter groups

    Tom Barnes


      So, not sure if this is possible but would love it to work properly.  I have a workbook where I want the user to be able to pick their time periods.  When they pick their time periods the workbook automatically makes a LY and TY.  The only problem is that if the time period is more than 13 periods I am not able to overlap the timeperiods into both LY and TY.  There are 13 periods each year.  So for instance if they choose time period 1 2012/03 thru 2013/07 then that would become TY and LY should be 2011/03 thru 2012/07 but that doesn't happen.  LY stops at 2012/02.  Is there anyway I can get around this?

       

      Workbook attached.