Is there a way to select (or at least only show) the last sequential record for a group?

For example I have a report that more or less looks like this

Group level 1
    Group level 2
          Record 1
          Record 2
          Record 3
          Record 4


I only want Record 4 to show in the Details section.

Any advice would be greatly appreciated.

Okay I am a space monkey. I figured out how to show only the last record. I just sorted descending and then placed the field in the group header. Haha. So simple. Anyway... any idea on how to sum only the visible fields?

Summing certainly is complicated. I thought maybe I could do something with TopN where N=1, but I'm not getting anywhere with that.
Don't you have to declare the variable for shared variables? Would that work where X would be whatever value is stored in the record.

Thanks for the reply DBlank. It is getting late in the day. I will have to try again tomorrow with fresh eyes.

As usual, your advice is perfect.

I am getting better at CR everyday and I am just amazed at how friendly and helpful everyone on this forum is. I really appreciate it!