What I am trying to accomplish using v11.5 is a line chart, with the horizontal data point being months, and the vertical data points being running totals by month. Pretty simple to do, except I would like have the lines overlay for 2012 and 2013 (year to date) so that the line for 2012 is complete for all months and the line for 2013 is complete through September. An example would be this image, except instead of "2005 HDD" and "2005 CDD" the line would represent "2012" and "2013"
I'm not sure if I can accomplish this through Crystal, or if I need to somehow create two separate views in the database and then bring them into Crystal. Any ideas for the best way to accomplish such a chart?