Line chart : Average value from start until value of point

[davoud-jelodar]

I have a table with these fields Symbol,Code,Value:

Symbol	Code	Value
S1	A1	110
S1	A2	100
S1	A5	105
S1	A6	108
S2	B3	120
S2	B5	150

I want to show a line chart with dim="Symbol" and exp="Value/AVG",  that AVG is average of value before current value. for example for symbol=S1 and Code=A5 the AVG is 105=(110+100)/2 and for Symbol=S1 and Code=A6, AVG is 105.75=(110+100+105+108)/4.

How I can do this?

[sunny_talwar]

Do you mean to have Code as your dimension?

[sunny_talwar · Accepted solution]

Something like this?

[davoud-jelodar]

Thanks. You help me alot.