How can we replace '-' while using above() on the first row with the corresponding value?

[that_anonymous_guy]

A	B
5	-
7	5
3	7
8	3

Column B is fetched using above() function i.e above(A)

Is there a way to get the corresponding value on first row instead of '-'  i.e 5?

[Or · Accepted solution]

There is no corresponding value as there is no value of 'A' above the first row of 'B'. That said, you could use e.g. Coalesce(Above(A),A) to use A any time Above(A) is missing, or you could get fancier with if() statements and row numbers.

[that_anonymous_guy]

it worked, thanks!!!