View the original community article here
Last tested: Mar 29, 2021
This assumes you've setup the group_start_row and next_group_start_row table calculations from the Window Functions in Table Calculations Community Post
row_offset_till_group_start:
if(row()=${group_start_row},0,0-1*(${group_start_row}-row()))
offset_number:${next_group_start_row}-row()+1
Grouped_list:offset_list(${field},-${row_offset_till_group_start},${offset_number})
max_in_group:max(${grouped_list})
This content is subject to limited support.