11 Replies Latest reply on Apr 30, 2013 3:07 PM by Shawn Wallwork

    End Running Total line at today

    Craig Willis

      I have a report that shows day by day running total progress v. a goal.  The data on the goal extends out until the end of the calendar year but the actual performance data runs only through the current date.  The actual progress comes from a live connection to our OPS Database and the goal sheet is a simple excel file.  When I do a running total once we go past the current date the goal continues on its intended trajectory but since there is no additional progress data that line goes flat until the end of the year.  I would like the actual progress line to stop at the point where there is no more additional data instead of going flat.  I have not been able to figure out how to accomplish this.  Attached is a packaged copy of the data, hopefully it is clear what I am looking to accomplish.

       

      Thank you.