8 Replies Latest reply: Sep 23, 2014 12:08 PM by Michael Lam RSS

    Set Analysis for Dynamic Past Two Year Total

    Jihan Wang

      Hello,

       

      I try to get dynamic sum of sale for previous two years. For example, when I select 2011, I would like to see the total sum of sale for Year 2010 and 2009, and when I select 2012, I would like to see the total sum of sale for Year 2011 and 2010. In the set analysis, which expression am I supposed to put for the field "Sale Year"?

       

      Thank you so much!