You can use a combination of data functions and aggregate functions executed in the scope
of the required group to identify the last row of this group.
Check this help article
containing all the built-in functions.
The attached report demonstrates the above suggestions (can be opened with Standalone Designer R1 2017).
Telerik by Progress
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?
Telerik Feedback Portal
and vote to affect the priority of the items