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