4 Replies Latest reply: Dec 14, 2011 6:55 AM by Luca V RSS

    SUM of MAX day by day

    Luca V

      Hi,

      i have a problem.

      i have many counters with growing values:

      COUNTER 1 , DAY 1 = 1

                                          2

                                         4

                                         7

      counter 1 day 2 =  9

                                    11

                                         18

                                    ecc...

      COUNTER 2 , DAY 1 = 3

                                          5

                                         6

                                         9

      counter 2 day 2 =  12

                                    13

                                         15

                                    ecc...

      i need a table that day by day make the sum of max value for each counter like:

       

      day 1 : 16 (max of counter 1 & counter 2 in the first day =7+9)

      day 2 : 33 (max of counter 1 & counter 2 in the second day = 18+15)

       

      i can make a table day by day but sum of max doesn't work...

       

      Thanks