1 Reply Latest reply on Jun 17, 2018 12:48 PM by Don Wise

    How to have a geometric mean and an arithmetic mean in the same table

    Jessica Rabit

      Hello,

       

      I have data which I am breaking down by categories.

      For some categories I need to calculate a geometric mean for the last 10 periods, for others I need an aritmethic mean per period and then an aritmethic mean over all the periods.

      Both means I would like to display in the same column - is this possible?

       

      I'm afraid I can't share my workbook.

       

       

      Many thanks!