2 Replies Latest reply on Mar 28, 2016 9:42 AM by Steve Demanovich

    Future values based on previous actuals

    Steve Demanovich

      Hello,

      I have a series of customers with historical sales for prior month, and each customer has varying expiration dates.  What I'm trying to do is populate the 12 months following each customer's expiration month with the values from the previous 12 months.  I'm thinking it's a simple formula but I haven't nailed it yet.  I have a sample data set attached.

       

      Thanks!

      Steve