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

    Total Sales by Sales Rep



      Total Sales by Sales Rep


      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