1 Reply Latest reply: Feb 12, 2013 11:35 AM by Andrea Rebora RSS

    Sales Trend rolling

      Hello,

       

      like always, I try to be clear to explain what I am looking for, and like always I need your help.

      I need an expression to set a bar chart where the dimension is 'Order Date'. The expression should be the sum of the value of the orders had in the prevous 365 days of each point of dimension. What I mean is that on the point of the dimension value 01-01-2013 I would have the sum of the value of the orders between 02-01-2012 and 01-01-2013, on the point of the dimension with value 02-01-2013 I would have the sum of the value of the orders beetween 03-01-2012 and 02-01-2013.

       

      it could be possible?

       

      I hope you can help me.

       

      Best regards.

       

      Andrea