Forum Discussion
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 looks like
My source data is also in the format mmm-yy but in the pivot table this format does not show.
Have attached file.
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
4 Replies
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
Can't open the file. If you work with data model PivotTable, simple pattern is here Computing running totals in DAX - SQLBI
