4 Replies Latest reply on Jun 13, 2018 9:51 AM by Kaushik N

    Month when Running Sum hits Threshold

    Kaushik N

      Hello All,


      I'm trying to find the particular month, when a person's running sales for 2018 hits 50 Million. I've tried multiple approaches but none of them seem to be working - For instance, using running sum table calculations/LODs to calculate revenue by month/...


      Attached is the sample data as well as the snapshot of the desired result.


      Any assistance in this would be most appreciated.  Also, please let me know if I need to provide any additional information.


      Thanks in advance,