13 Replies Latest reply: Apr 25, 2016 10:19 AM by gustavo gajardo RSS

    sum two maximum from the start

    gustavo gajardo

      Hello everyone !

       

      I have a list with sales date in this format (eliminating the time, so there are recurring dates) and the sales.

       

      DateSale
      31-07-2015
      10
      31-07-2015
      11
      03-08-2015
      12
      03-08-2015
      12
      04-08-2015
      5
      04-08-2015
      9
      05-08-2015
      15
      06-08-2015
      8
      07-08-2015
      8
      10-08-2015
      3
      10-08-2015
      20
      10-08-2015
      9

       

      I want to make a line graph showing me the sum of the two highest sales since the beginning of time starting from the first date. Thus becomes:

       

      DateSale
      31-07-2015
      21
      03-08-2015
      24
      04-08-2015
      24
      05-08-2015
      27
      06-08-2015
      27
      07-08-2015
      27
      10-08-2015
      35

       

      I have tried many "measures" to make this graphic but no results. Any suggestions?

       

      Regards !