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!
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
Retrieving data ...