9 Replies Latest reply: May 19, 2014 7:04 AM by Prem Kumar Thangallapally RSS

    Set Analysis Questions: Cumulative function in the past

      Hello,

       

      I want to compare a period of this year with the same period last year.

       

      For example: Jan, Feb, Mrt 2014 vs Jan, Feb, Mrt 2013.

       

      I have now the following, but it doesn't work proper:

       

      sum({$<Date = {">=$(=Date(addyears(Min(Date), -1)))"}, Date -= {"<=$(=Date(addyears(Max(Date), -1)))"}>}visitors)


      It is on expressions level and has to work wiht selections.


      Can you give a suggestion what to change?


      Thanks,

      Marc