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

    How to achieve previous week data.

    Chandra kanth



      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.



      Chandra kanth.