Table Get the last row or Item

2 posts, 0 answers
  1. Aubrey Ivan
    Aubrey Ivan avatar
    26 posts
    Member since:
    Oct 2019

    Posted 13 Feb Link to this post

    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?

  2. Neli
    Admin
    Neli avatar
    252 posts

    Posted 17 Feb Link to this post

    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

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top