2 Replies Latest reply: Nov 16, 2017 11:31 PM by Luis Madriz RSS

    Most Recent Sales by Salesperson

    Todd Lambourne

      I need help solving a situation. Let's suppose I have a table with up to 3 records for each salesperson. The date will have a Sales Date, Sales Person, and Sales Amount. I need a formula to calculate the average sales using only the most recent sale for each Sales Person.

       

      Any ideas?

      Thanks in advance.

      Todd