Skip to main content
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I do ?

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!

1 Reply


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