4 Replies Latest reply on Feb 7, 2017 2:05 AM by Ian Barton

    Moving Annual Total - driving me mad

    Ian Barton

      Hi All,

       

      Im trying to create a Moving Annual  Total i.e running 12 months sums from monthly sales data.( as seen in MAT sheet attached) Ive used the following formula:

      window_sum(sum([Measure]),-11,0)

      Firstly the calculation doesn't work, and when i try and replicate the chart in the MTH Sales tab., the measure turns red. I think its something to do with the Date pills being Blue and not green

      Currently the MAT chart is separated by yearly 'buckets' which is unsightly. How can i make it so that it looks like the MTH Sales chart please?

       

       

      Many Thanks