Getting SSRS line chart series to represent cumulative values by time
Posted on 2010-09-08
I have a line chart in my SSRS report that shows commission over time. The series group consists of two years, 2010 and 2009 so there are two lines running across my chart to represent each year. By default the chart is representing the sum of January followed by the sum of February, etc. What I need is for it to represent the series values cumulatively so you can see the sum of January followed by the sum of January and February, etc.
How is this best done in SSRS?
Many thanks in advance.