7 Replies Latest reply on Sep 24, 2018 9:59 AM by meenu choudhary

    Custom Aggregation Help

    Sam Daly

      Hi,

          

      AccountSales Rep     $ Date
      Acme 1John1001/01/2018
      Acme 2Jack1001/04/2018
      Acme 2Jack2020/06/2018
      Acme 1John521/06/2018
      Acme 2Sam101/09/2018

       

      I need to aggregate this such that the last sales person for the Account gets all the $ revenue associated to them. For example the above would aggregate to this:

       

       

          

      Account

      Sales

      Rep

            $
      Acme 1John15
      Acme 2Sam31


      How could I do this?

       

      Thanks in advance!
      Sam