Knowledge Drop
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})