Forum Discussion
Solved
How to stop Running total (cumulative) resetting after year change
I'm trying to show a graph with Cumulative figures, but the figure resets when year changes how do I stop this and keep the the running total throughout. Screenshot attached of what it currently loo...
Finally opened it. You are on cached PivotTable. What I'd suggest
- in Master sheet use =EOMONTH() to define month, not just date formatted as month. With that you have same value for each month
- in PivotTable don't group by years. Such grouping resets running total for each next year. Just proper formatted months is enough
Thank you this worked
excel_learner , you are welcome