3 Replies Latest reply: Mar 4, 2015 3:02 AM by Sebastian Schäfer RSS

    Calculating MAX over a dimension of a straight table for every row

       

      I would like to calculate the maximum value of a group of rows in a straight table and use it for every particular row to calculate ratios.

       

      As an example please see table below. The last column should display the maximum value for each country, i.e. 35 for the first three rows, 57 for the next three etc.

       

      I tried

      =Aggr(Max(Aggr(Sum(Units), Country, Product)), Country),

      but unfortunately as it shows in the picture this only gives values for the lines with ‘Apple’ and NULL for the others L

      table2.jpg