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...
That is precisely the way I checked my formula!
So, PeterBartholomew1 , wouldn't the principle of "Occam's Razor" apply -- use the simplest solution. (?)
😉