15 Replies Latest reply: Apr 16, 2014 12:12 PM by Dariusz Mielczarek RSS

    compare set of rolling months

      I would like to compare a set of month with the same set of month -1.

      ie. if I highlight the months Jan2014-Feb2014-March 2014, I would like to have a column next to the previous where I have the sales value of Dec2013-Jan2014-Feb2014.

       

      Year
      2011201220132014
      months
      janfebmaraprmayjunjulago sepoctnov dec

       

      sales
      jan '14feb '14mar '14dec '13jan '14feb '14
      client
      client
      client
      client
      client
      client

       

      if I highlight 5 months I'll have the comparison Jan'14/Feb '14/Mar '14/Apr '14/May '14 VS Dec '13/Jan'14/Feb '14/Mar '14/Apr '14 and so on...it is possible (and if yes, how) to do it through set analysis or I need to write a macro?