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



      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!