Difference betweend two rows

jkk

Hi,

I have the data in following format:

Name, Number
X,5
Y,10
Z,15

and I would like to calculate difference for each row against X value, i.e. Y-X, Z-X .

Any ideas?

Thx,
jkk

Tubal

This might help:

http://www.birt-exchange.org/org/forum/index.php/topic/21623-calculate-from-previous-row/