3 Replies Latest reply: Oct 3, 2014 7:47 PM by Sean Ziai RSS

    Set Analysis : Finding a way to calculate selected week vs previous week

      Hi All,

       

      I'm trying to develop a set analysis expression where a user clicks on a specific week in a list box in date format, and then a text box automatically calculates a Week Over Week analysis based on the selected week vs the previous week. 

       

      Example : User clicks on 8/18/2014.  A text box would show the percentage difference between the selected week and the previous week in regards to sales.

       

      Is this possible? Is Set Analysis the best to use in this case?