5 Replies Latest reply on Dec 5, 2018 7:49 AM by Ken Flerlage

    How to make a running total only display if there is a change for a given increment?

    Keith Price

      Basically I'm plotting the cumulative % of a measure over time.

       

      The lines that I'm plotting each correspond to a certain year that the item started.  There are lines for each 'starting years' from 2009 onward.  Therefore, it looks ugly when it's plotted with years for which there hasn't been as much time because there is a flat line showing for these measures and it makes the original picture more difficult to discern.

       

       

      The straight horizontal lines shown above are the lines I'm trying to get rid of.  They show as a flat line because there is no change for those months (because those months are in the future from today).  Any help or ideas?

       

      Thanks!