9 Replies Latest reply on Jun 13, 2017 9:47 AM by Hari Ankem

    Window average using parameter

    chris .

      Hi All,

       

      I'm having an issue specifying a window average that I was hoping somebody could help me with.  I have weekly sales data for departments (each department may have multiple rows) where the week in the view is indicated by a parameter (the calculation is: if [week] = [week parameter] then [sales] end).  I'd like to add a column that averages the data for the week specified by the parameter and the previous three weeks.

       

      I've attached a sample workbook to illustrate the problem.  Any help is much appreciated.  Thank you!

       

      chris