String related to max value

[#1]

Hi,

I have the following data in a pivot table:

MODEL	Segment	TYPE	SUB_TYPE	Engine	sum ( Measure )
A4	D	A	A1	aaa	879
A4	D	A	A2	bbb	14
A4	D	A	A3	ccc	828
A4	D	A	A4	ddd	20
A4	D	A	A5	eee	0
A4	D	A	A6	fff	63
A4	D	A	A7	ggg	1
A4	D	B	B1	hhh	8
A4	D	B	B2	iii	10
A4	D	B	B3	lll	1
A4	D	B	B4	mmm	0
A4	D	B	B5	nnn	4
A4	D	B	B6	ooo	2
A4	D	B	B7	ppp	0

My issue is to visualize Engine description (string) according to the max value of Measure, as in the below table.

MODEL	Segment	TYPE	SUB_TYPE	Engine	sum ( Measure )	max(TOTAL<TYPE,MODEL> aggr(sum(Measure),MODEL,TYPE,SUB_TYPE))
A4	D	A	A1	aaa	879	879
A4	D	A	A2	aaa	14	879
A4	D	A	A3	aaa	828	879
A4	D	A	A4	aaa	20	879
A4	D	A	A5	aaa	0	879
A4	D	A	A6	aaa	63	879
A4	D	A	A7	aaa	1	879
A4	D	B	B1	bbb	8	10
A4	D	B	B2	bbb	10	10
A4	D	B	B3	bbb	1	10
A4	D	B	B4	bbb	0	10
A4	D	B	B5	bbb	4	10
A4	D	B	B6	bbb	2	10
A4	D	B	B7	bbb	0	10

I got the max of the sum(Measure) grouped by Type, but I'm not able to visualize the correct string.

Could anyone help me?

Thanks a lot,

Davide