Table Get the last row or Item

[Aubrey Ivan]

I have some thing like this

COL1    COL2
a            1
b            2
c            3
d            4

              4 =====> this is what im asking for

I want to get last item of the row.. I have been using sum and its helpful but this time I want to get the last item. how do I do that?

[Neli]

Hi Aubrey,

After the table is created, right-click over it -> Add Row -> Outside group Below. Then in the new row, you need to use the Aggregate function Last:

= Last(Fields.Column2)

 The attached report demonstrates the solution.

Regards,
Neli
Progress Telerik