I know how to get a rolling total from data, but this is different. I have a dataset where I need to see each rolling total of [HOURS] for all the preceding 12 month periods for a unique [KEY_c]
For example, what is the total hours from Jan2024 - Dec2024, Feb2024 - Jan2025, Mar2024 - Feb2025, etc... The dataset only contains data from any given 2 years, so there are only 12 sets of rolling periods.
I've attached a spreadsheet with sample data and results, but there is also a screenshot of the results I'm trying to achieve.
