Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ronin666
Starting Member
2 Posts |
 Posted - 2011-02-27 : 16:27:45
|
| 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 Amount2011/01/04 100,202011/01/07 63,902011/01/07 47,502011/01/14 223,40and so on.... to keep ist simple: The dataset returns the due Date and the Amount of customer invoicesWhat 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 |
|
|
Ronin666
Starting Member
2 Posts |
Posted - 2011-02-28 : 07:20:12
|
| Problem solved: i should have tried the RunningValue function before posting this thread... |
 |
|
|
|
|
|
cumulative Values in Line-Chart