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.
I know lots of ways that don't work!
I'm at my wits end, help please...
Thanks in advance.
David