Create a new column based on a group

[william117]

I try to make a column where TotalData, contains several components, the idea is that it can identify what it belongs to by name and not by group_id, this is the example

PRODUCT_ID	GROUP_ID	NAME	IN	OUT
1	GROUP1	DATA1		150
2	GROUP1	DATA2		12
3	GROUP1	DATA3		44
4	GROUP1	DATA4		75
5	GROUP1	DATATOTAL1	281
6	GROUP2	DATA5		400
7	GROUP2	DATA2		50
8	GROUP2	DATA6		200
9	GROUP2	DATATOTAL2	650

the result i try to do

PRODUCT_ID	GROUP_ID	NAME	IN	OUT	new column
1	GROUP1	DATA1		150	DATATOTAL1
2	GROUP1	DATA2		12	DATATOTAL1
3	GROUP1	DATA3		44	DATATOTAL1
4	GROUP1	DATA4		75	DATATOTAL1
5	GROUP1	DATATOTAL1	281		DATATOTAL1
6	GROUP2	DATA5		400	DATATOTAL2
7	GROUP2	DATA2		50	DATATOTAL2
8	GROUP2	DATA6		200	DATATOTAL2
9	GROUP2	DATATOTAL2	650		DATATOTAL2

I hope someone can solve my question, thanks for your time

[amitchandak · Accepted solution]

@william117 , Try a new column like]new column =
maxx(filter(Table, [GROUP_ID] =earlier([GROUP_ID]) && not(isblank([IN]))), [NAME])

[william117]

it worked perfectly