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...
mathetes I've produced this very slimmed down example.
Can you access it https://1drv.ms/f/c/63f5269daec16288/EnLi31YsZAlBqa8tu4pOLYQBlYyUR9kePeoDYsL3Mje5Lw?e=64ahBm
Thank you for your help.
Yes, thank you. We can access it, which will go a long way, as I said, toward getting your answer.
I'll look at it further, but my first impression is that you're making this far more complicated than it needs to be.
My guess is that a couple of the others who've already offered more sophisticated suggestions than mine will now be able to see this example and jump in.