3 Replies Latest reply on Aug 27, 2018 9:12 AM by Susan Miller

    Pulling dates first time running sum of sales surpass certain number by Reps?

    Susan Miller

      I have a table displaying sales by individual sales reps that looks something like this:

        

      Rep IDOrder DateSales
      18/1/2018698
      28/2/2018865
      38/3/2018984
      28/4/20181266
      28/5/2018437
      38/6/20181690
      28/7/2018805
      18/8/2018497
      18/9/20181664

       

      What I'm trying to do is pull the first time each Rep's sales surpass a certain number - so for example, if I want to see the date each Rep's sales surpass $1,000, each Rep would show the following dates:

       

      Rep IDDate sales surpassed
      18/8/2018
      28/4/2018
      38/6/2018


      Can anyone help me out? I'm totally stuck!

       

      EDIT: I'm looking for a running sum of sales by Rep - so for example Rep 1 should show a date of 8/8 (NOT 8/9) since the sum of his sales on 8/1 and 8/8 total to 1,195.