Rolling 12 Months: Moving Totals, Averages and a Trend Chart
This lesson is part of the course
In this lesson
You calculate Larkspur's rolling 12-month (R12, also called LTM or TTM) totals and averages, the R12 for any report month with a SUMIFS window, and chart the smoothed trend.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Month Keys with EOMONTH: Group Any Date into Its Month Locked
- Month-to-Date (MTD): SUMIFS Between the Month Start and the Report Date Locked
- Year-to-Date (YTD) and Prior-Year YTD with SUMIFS and EDATE Locked
- Year-over-Year (YoY): Variance, Growth % and the "New" Case Locked
- Rolling 12 Months: Moving Totals, Averages and a Trend Chart Locked
- Fiscal Years Starting in April: FY, Fiscal Quarter and Fiscal YTD Locked
- Like-for-Like (Same-Store) Growth with COUNTIFS Flags Locked
- Capstone: KPI Tiles (Month, YTD, YoY, R12) and a Current vs Prior Year Chart Locked