3 Replies Latest reply on Dec 21, 2018 1:48 PM by Jim Dehner

    Sum of last 4 weeks sales for every week

    Pradeep Ooralath

      Hi,

       

      I found a lot of threads about rolling 4 weeks but none of them suited my requirement. I have a dataset which contains all the orders received by my company. The dataset has a date field and a sales price field for every order. I want to create a graph which shows the total sales for the last 4 weeks, every week.

       

      I have attached a workbook which has the sample data and a graph which shows the total sales for every week. I want a similar graph which shows the total sales for the last 4 weeks instead of one week.

      I hope that makes sense and very grateful for any help. Please let me know if any clarification is needed.

       

      Thanks,

      Pradeep