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...