Forum Discussion
Solved
Monthly Cumulative total
Hi, I'm trying to create a report that shows the current months total to date (From the beginning of the month to the selected date). That's easy, but I then also want to show what previous months c...
I have ended up using this:
Rolling Total = IF(ISBLANK('Sales'[Total Sales]),BLANK(),TOTALMTD('Sales'[Total Sales],'Calendar'[Date]))
It gives me a running total for each month so that an easy comparison can be made.
I have ended up using this:
Rolling Total = IF(ISBLANK('Sales'[Total Sales]),BLANK(),TOTALMTD('Sales'[Total Sales],'Calendar'[Date]))
It gives me a running total for each month so that an easy comparison can be made.