5 Replies Latest reply: Dec 14, 2013 6:31 AM by Jeroen Jordaan RSS

    Sales per date for 10 days earlier

    Jeroen Jordaan

      Hello everyone,

       

      I hope somebody can help me with this.

       

      A customer needs to have a Straight or pivot table with the dimension date.

      For me this is the easy part :-)

       

      As an expression I need a formula that is calculating the sales but only for 10 days earlier.

       

      See the example below

       

      DateSalesSales 10 days Earlier
      2013-11-21100 for the date 2013-11-21This should be the sales from the date 2013-11-11
      2013-11-20250 for the date 2013-11-20This should be the sales from the date 2013-11-10
      2013-11-19175 for the date 2013-11-19This should be the sales from the date 2013-11-09
      2013-11-18150 for the date 2013-11-18This should be the sales from the date 2013-11-08

       

      This table also needs to change to a line graph.

       

      Thanks in advance for your time