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,

       

      Kaushik