can I call the value from a last row in an expression

[#1]

HI ,

can I call the value from a last row in an expression

best regards.

[#2]

Yes use Previous() or PEEK() functions

[#3]

thanks yaseen ,

but in my expression editor didnt appear the function peek or the function previous,

what I need to do?

best regards

[julian_rodriguez]

Previuos() and Peek() are functions for Loading script.

You can use the function "Bottom(FieldName)", to get the last row for each dimension value, or "Bottom(Total FieldName)" to get the last row for all dimensions values.

Hope this helps

Regards

[#5]

Thanks Julian ,

but ,what if I need a specific value and not only the last?

I mean , what I really need Is an increment field  , if I had an value for example 1 in my row and the next row 4 the value would be 5 considering the increment.

there's any way to do that in QV.

Thank you very much for your help.

[julian_rodriguez]

Could you please place an exampe with a table?... because the functions I mentioned do that, based on the current selections..

[#7]

thanks Julian ,

I think I got it but it not work in a pass version, I mean in the version 11 just select the option for accumulation in the expresions part, but in the version 8.5 this is not work, have you  any idea about what's up.

best regards.