1 Reply Latest reply on Mar 20, 2015 3:13 PM by philmodjunk

    Total Sales by Sales Rep

    Michael_3

      Title

      Total Sales by Sales Rep

      Post

      Hi Guys!

      I'm looking for a solution on how to get total sales (current month or current year) by sales rep. (John and Joe). For each order, sales reps are selected via dropdown so this field would need to always be calculated to keep it up to date.

      For example:

      Order #1 Sales: $50 (John)
      Order #2 Sales: $60 (Joe)
      Order #3 Sales: $40

      Total Sales: $150
      John Sales: $50
      Joe Sales: $60

      Thanks!