7 Replies Latest reply on Jan 8, 2019 6:11 PM by tian.yang.4

    Calculations for Average of Max 4 Week Sales

    morgan.suttich.1

      Hello -  I am trying to calculate the average of the highest for weeks of the year. My data set has 52 weeks of data for 15 categories and I am looking to find the average of the highest 4 weeks, they are not always sequential weeks. It could be Week 10, 22, 21 and 52.

       

      It is the same function as Large and Small in Excel - but I cannot find a way to replicate it. The number of weeks to calculate I would like to be a dynamic parameter.

       

      I have tried Ranking and Window_Avg - but you have to have all of the weeks showing and I am just looking for one number.