1 Reply Latest reply on Nov 22, 2014 12:24 PM by Shawn Wallwork

    TTM from different dates

    Jerry Pudmanski

      Hi experts,

       

      I am working on the attached worksheet and was able to create a report showing profit from different locations 18 months from the date each location was resold(18 MO After tab). I want to be able to also look 18 months back from the resale date to see if there has been an improvement. 

       

      I thought the easy answer was to change the formulas for the month  and profit would give me the results but it didn't work.  How would I get the prior 18 months?

       

      thanks

        • 1. Re: TTM from different dates
          Shawn Wallwork

          Jerry, I suspect the reason you didn't get an answer to this is because you posted a complex workbook. Simplify it down to just a few fields and repost, and I'm sure someone will come up with an answer for you. (I won't, as I don't do text tables any more.)

           

          --Shawn

           

          EDIT: Also call it something other than TTM, I still don't know what that's an abbreviation for.