6 Replies Latest reply: Aug 20, 2015 11:45 AM by jagan mohan rao appala RSS

    compare d-7 sales to prior week



      I'm quite pleased with my progress so for but now it looks like I need a little help from the community:


      I was able to calculate the sales of the last week by building the following expression


      Sum({<OrderDate = {'>=$(=Date(Max(OrderDate)-6))'}>} Sales)


      my next step is to compare this value to the sales of the week before


      Starting on: Max(OrderDate)-13

      Ending on: Max(OrderDate)-7


      Could you help me with this expressions?