1 Reply Latest reply on Dec 14, 2012 8:00 AM by Jonathan Drummey

    How Do I create a window_average using the top 'n' values in the window?

    Renelle Risley

      I have a data set that lists total values by month for a category.  Within the window, I want to average the top 3 values for a category.  The top values are defined as totals per month for each category.  A sample is below:

       

      OPH     December     125

                    January          50

                February          145

                March               90

                April               150

                May                160

       

      I need an average of the top 3 months (in this example, Feb, Apr & May).  Help!  Thank you.  Renelle