2 Replies Latest reply on Nov 20, 2013 4:10 PM by Shawn Wallwork

    Adjust Period1 over Period2 comparison based on selection

    Ivan Klimovich

      Hi everyone.

       

      Usually I make Period over Period comparison by creating 2 parameters "start" and "end" and calculating intervals based on what user have selected.

       

      Now I need to make following:

       

      If I select "January" on the chart the comparison should calculate "January"/"December"

      If I select "January" + "February" it goes back 2 months and calculates ("January" + "February")/("November" + "December") etc.

       

      Attached workbook shows what I currently have. I need to replace "comparison"  chart with the one which will be adjusted according to selection on "sheet 1"

       

      Thanks a lot for reading that.