SSRS 2008: cumulative values in line-chart
Hello, i don't know whether this question is silly, but i don't get the answer by myself. I've got the following situation: A dataset that returns the following records (e.g.): DueDate Amount 2011/01/04 100,20 2011/01/07 63,90 2011/01/07 47,50 2011/01/14 223,40 and so on.... to keep ist simple: The dataset returns the due Date and the Amount of customer invoices What i want to do: create a liquidity report that shows me per day what payments can be expected. I want to display this in a Line Chart with the Due Dates on the x-axis, cumulated amount on y. the problem is the cumulated amount: when i group the data by due date (to get only one value for one day), the chart also groups the amount per due date. but to get a cumulative chart i need the amounts cumulated up (!) to the due date. e.g: (see example above): for the x-axis value 2011/01/07 i need a y-value of 211,60 (all amounts up to this due date). But the line chart just gives me 47,50 (amount value grouped for this day). So... how can i make the line-chart display the cumulated amounts??? I hope my description and english ist sufficient. Any help is really appreciated as i`m really going mad on it... (and don't tell me it's just one click...) Thanks! Henning
February 27th, 2011 4:34pm

Try the RunningValue function http://msdn.microsoft.com/en-us/library/ms159136.aspx
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2011 8:04pm

wow... it was that easy... i must admit i didn't know that function but it solved my problem in 2 min... thanks a lot
February 28th, 2011 5:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics