Trailing Twelve Months

I want to add a column to an existing data set that gives me trailing twelve months (TTM) of the amounts instead of just that day. Is there a way to do that in ETL?


  • Have you checked out the new Rank & Window transform (under edit columns) in ETL yet?  This might have what you're looking for.


    The details might be tricky based on your data, but you'd likely use the SUM function in that transform over a certain number (or all) of your preceding rows.

    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"