0 Replies Latest reply: Sep 24, 2013 8:07 AM by Jaskirat Sareen RSS

    SUM of sales of selected month and previous 2 months.

      I have an expression for calculating the 3 months average from the selected month.

      Suppose if Aug 2012 is selected then it would sum up June,July, August sales.
      but when i introduce the Date ( MM/DD/YYYY) format as the dimension then it doesnt seem to work.
      It only does the sum of current month.

      I use the xpression sum({<Month Name={$v(Date)}>}sales) where vDate =Aug,Jul,Jun if the selected month is Aug.
      this expression works well till no date field is introduced as dimension .
      On addition of date field
      suppose if
      Aug Sales=30

      Jul=20

      Jun=10 then instead of showing 60 it shows 30 only .