10 Replies Latest reply on May 8, 2013 1:55 AM by Rajini S

    How to find previous 4 week change % with week filter

    Rajini S

      Hi All,

       

      I am facing issue to find previous 4 week change %.

       

      Ex. I need Wk 10th previous 4 week % and calculation as below,

      Wk 10 - 761

      Last 4 week average - Wk 9 to Wk 6 = 757

      % Change               - (761-757)-757 * 100 = 0.53 %

       

      I am able to achieve the above logic in attached sample file using window calculation and I am able get % change for all week.

      When I use week filter then window calculation does not work. It is simply returning null.

      Anyone have idea how to get last 4 week % change with week filter?

       

      Best Regards,

      Rajini