Hi all, I want to chart monthly moving annual total and find using 12 steps back works ok unless I have a month with no sales and then 12 steps back just finds the last 12 where there is something and adds those together. If I tick show all values this also shows the current incomplete month even though I have set the formula to only count closed months.
