Row specific selections

[#1]

Hi.

I am trying to get the bottom most record and then go up five rows and perform an expression calculation.

For the fourth row from the bottom, I have another calculation and so forth.

The challenge I found using bottom is that if I say bottom(column xxx, 5) is that it takes the value in the bottom most row in column xxx and replicates it over each row of the bottom five rows.

I tried searching for an alternate function but could not find an equivalent. I cannot use rowno() as the number of rows can vary each time.

Would appreciate any assistance.

Thank you.

[Gysbert_Wassenaar · Accepted solution]

Try something like this:

pick(NoOfRows()-RowNo()+1,'Bottom','Next to bottom','Nearly bottom','Almost bottom','Close to bottom')

[#3]

Thank you so much!