Generate a line Chart

[#1]

Hello Together,

unfortunately, I could find nothing in the forum and need some help.

Given:

The field [date] has, for example, 4 records. To every [date] there is n [values].
To every [date] there is in the field n [values].

For example:
5/5/2010-> 10; 10 ; 13 sum= 33
5/6/2010-> 8; 9 sum= 17
5/7/2010-> 12 sum= 12
5/8/2010-> 5; 8; 10 sum= 23

the goal:

I want a line chart. The X-axis should indicate the available [date], e.g., 5/5/2010, 5/6/2010 5/7/2010 ...

For the date 5/5/2010 the sum 33 = 33 should be associated. y = 33
For the date 5/6/2010 the sum 33 + 17 = 50 should be associated. y = 50
For the date 5/7/2010 the sum 33+17+12 = 62 should be associated. y = 62
For the date 5/8/2010 the sum 33+17+12+ 23 = 85 should be associated. y = 85

How I do make this? How must the formula look in the chart? Thank you very much !

[#2]

3.

[#3]

4.

[#4]

Hi together,

now i hope it is clear what i try to explain. Anyone a idea ? !

Thank you

[#5]

OK, I think you might need to use the RangeSum() function with the Above() function to do this, I have an expression like this

=RangeSum

 ( Above ( Sum ( Cost ) , 0 ,RowNo() ) )<pre><h4>
The above function takes the sum of all values for cost, starting at this row (this is where the 0 is placed) and including all rows above (identified by the RowNo() item which means current row). Try to adapt this to your chart. </h4></body>

[#6]

Hi Nigel,

Anyhow why I cant do this. I am going crazy. This is my source formula

etkp =

Sum( Imps) * 5.80 / ( ( Max(num([Datum])) - num([sdatum]) + 1 ) * 1368 )

How must my formula with the Rangesum look ? I tried this, but it wont work

=above (Sum( [Imps] ),0,RowNo() ) * 5.80 / ( ( Max(num([Datum])) - num([sdatum]) + 1 ) * 1368 )

Can you customise my formula please ?

Thank you very much

[#7]

I'm pretty sure it should be:

=RangeSum ( Above ( Sum ( [IMPS] ) ) , 0 , RowNo() ) * 5.80 / ( ( Max ( Num ( [DATUM] ) ) - Num ( [SDATUM] ) + 1 ) * 1368 )

Try that...

[#8]

Hi Nigel,

unfortunately its not the result that if have expected.

The Resutls are wrong !

look at my pics and qvw, please. Can you edit my qvw (look above) and so to show it to me ?

Thank you