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