8 Replies Latest reply on Nov 23, 2017 3:22 AM by Jim Dehner

    Another AverageIFS clarification

    Vivekanandan Venkatesan

      Is it possible to calculate a window average upon the Dim1 and display the same calculations on a dim 2 without showing dim 1 anywhere in the sheet(Hiding the dim is not an option). If I remove the dim1 from the sheet the window_avg calculates overall average even after giving input in the Calculation definition under default table calculation. refer the excel for the requirement.

       

      Kind Regards,

      Vivek.