4 Replies Latest reply: Nov 27, 2015 4:51 AM by Betty Habtemariam RSS

    Set analysis and start month

    Betty Habtemariam

      Hello,

       

      my name is Betty and I'm new at this. I want to make a set analysis where I compare this years sale to last years sale and I want to start from January. I've actually made one, but can't seem to figure out how to make it start from january. Can you please help me out a little? =)

       

      This is the expression I've written (know that I don't use dollar signs since I' m a swede):

       

      sum({<year={2014}>}sales)

      sum({<year={2015}>}sales)

       

      Also, this store opened 2014 and so I only have sales information from 2014-2015, but let's say that 2016 comes. I don't want to have to write another expression only for that year. Is there also a better way to make an expression that will apply to all years?

       

      Sincerely,

      Betty