0 Replies Latest reply: Mar 30, 2011 12:17 PM by David Simpson RSS

    Sales chart moving annual total

    David Simpson

      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