3 Replies Latest reply on Oct 5, 2012 12:10 PM by Alex Kerin

    More Compound Dates

    Sam Bruce

      I have a set of sales data by product by week. It is recorded as a date (and numeric) as a Saturday.  I'd like to show each of the last 4 weeks as well as a total of the last 4 weeks.  I would think this to be something easy but I'm at a loss.

       

      Product  Wk1    Wk2   Wk3   Wk4  Sum(Wk1...Wk4)