6 Replies Latest reply on Jul 18, 2018 8:08 AM by Siobhan Magee

    LOD Max of a Sum

    Siobhan Magee

      Hi,

       

      I've got a simple dataset as attached.  I'm trying to find the right calculation to return the max.  I've got clicks by brand by date on Sheet 1.  On Sheet 2, I need to be able to select a Brand and bring back the max; so on the 09/07, the max is 14 for Brand A.

      The difficulty seems to be that I need the max of a sum at brand level by date.  I would be grateful for any help to resolve this.

       

      Thanks,

      Siobhan