2 Replies Latest reply on Apr 7, 2019 8:15 PM by tom.coombs.1

    Cut off running sum line

    tom.coombs.1

      I have a chart with a Running Total. The data stops mid way through the period, but the line on the chart doesn't stop. It shows all the way to the right edge of the chart, as if the sales went totally flat.

       

      I've made a workbook that boils the problem down as simply as I can. It's attached.

       

      If I set the date filter to Jan 1 - Feb 15, then it works fine. The Feb line stops at the 15th.

      If I set the date filter to Dec 1 - Feb 15, then it doesn't work. The (orange) Feb line stretches across horizontally all the way to the right edge of the chart.

      Untitled 5.png

       

      Thanks in advance.

       

      Btw there are many threads about this issue but I can't find one that solves it for me.

       

      End Running Total line at today

      Stop running total line in the last data point. It continues as a flat line...

      Is there a way to have a running total stop?

      Cut-off Running Sum Mid-Year

      Cut Off Running Sum Line after 'Today'