6 Replies Latest reply: Jul 20, 2017 2:11 AM by Sada Siva RSS

    Promotion event wise Data - last 'n' Days

    Sada Siva

      Hi Team,

       

      I have a list of promotion events, Promo_start_date and Promo_end_date, lets consider i am having promotion events for last 3 years.

       

      To show the current year and last year Promo sales, i am using

       

      Sum({<year={$(=max(Year))}>}sales) 

       

      and


      Sum({<year={$(=max(Year)-1)}>}sales)

       

      Next i need to show last 7 days sale. When i use Max(promo_to_Date)-7, it's not throwing desired output, how can i build the expression?

       

      Help me on this. Thanks in advance.

       

      Regards,

      Sadasiva