5 Replies Latest reply on Sep 23, 2019 6:23 AM by Jim Dehner

    Using Running sum to find out when the benchmark was achieved

    Ujval Gandhi

      Need support with an issue

       

      I have sample data attached at CustomerID, OrderDate & Revenue

       

      I want to construct a LOD calculation that allows me to see how many days have elapsed before the Customer hit a million dollars in revenue.

       

      Example Customer 5012 crossed million dollars on Day 157 whereas customer 8680 crossed on Day 31