2 Replies Latest reply on Mar 9, 2016 2:46 PM by DanPryke

    How to achieve previous week data.

    Chandra kanth

      Hi,

       

      I have a requirement where in the report have the following columns.

       

      Product, Sales, Current Week sales, Previous week sales

      ===================================

       

      XYZ     1000    34 (week sales)     33(week sales)

      RST      1200    45 (week sales)     44(week sales)

       

      I am unable to write a query to get the  previous week sales column data. Please advice.

       

      Regards,

      Chandra kanth.