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