4 Replies Latest reply: May 12, 2016 1:36 PM by Sunny Talwar RSS

    calculation of delta

    Mariano Candau

      I have a table with 3 columns: date, sales rep, amount.

       

      Example:
      day1 | John | 4

      day1 | Alan | 6

      day 2| John | 5

      day 2 | Alan | 9

      day 2 | Mary | 4

      .....

       

      I need calculate the delta of each sales rep, including the amount of the last day and the average every day.

      The result may be another table or a crosstable.

       

      Could you help me, please ??