How can I do ?

[#1]

rownum month value1 value2

1 1 543 Null

2 2 550 550-543

3 3 560 560-550

4 4 558 558-560

.................

.

.

.

.

value2's value is got in this way:next row's value1's value-this row's value1's value.

How can I get the value in QV? what's the function?and can anyone give me a sample,thank you!

[Miguel_Angel_Baeyens]

Hello,

Assuming you are drawing a pivot table, that rownum and month are dimensions and value1 is an expression

Above(value1) - value1

Using inter record functions will give you what you want.

Hope this helps