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

    compare d-7 sales to prior week

      Hello,

       

      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?

       

      Thanks

       

      Tom