Forum Discussion
Best way to get rolling 12-month totals
I am using Excel for Mac version 16.102. I have data in a Table which is basically date, category & value. There are many other columns I use for filtering. I pivot this data to get totals by month...
To create and aggregate a rolling range, I use a TAKE/DROP combination.
=LET(
counter, SEQUENCE(ROWS(amounts)),
MAP(
counter,
LAMBDA(k,
IF(
k >= 12,
SUM(TAKE(DROP(amounts, k - 12), 12)),
""
)
)
)
)