Creat a table with total by N°order

[Louveduval]

Hello 

I'm sorry to bother . I've a table with a lot of  fields and I would like creat a new field Total Order  who take just the sum amount for a same order number .

More or less like that : 

Client	N°order	product	seller	date	Amount	Livre ?	total order
A	01	tele	xxx	today	1500	O	1550
A	01	telecommande	xx	today	50	O
A	011	aquaruim	xxa	today	3000	O	3000
A	012	canne a peche	xx	today	120	O	120
B	615	tele	xxx	today	1500	N	1550
B	615	telecommande	xx	today	50	N
B	666	CD irunmaiden	xxa	today	6,66	O	6,66
C	007	film	xcc	today	30	O
C	007	pistoler	xcc	today	50	O
C	007	alcool	xx	today	75	N	155

I'm trying  : Sum({<[N° Order]=>}distinct [Amount]) but it doesn't work :c 

Can you help me ? 

Best regard

[brunobertels]

hi 

may be this 

Sum(

Agrr( No distinct sum( total Amount), N°Order))

[menta · Accepted solution]

SUM( Aggr( SUM(total) ,Client,N°Order))

to aggregate by client and Number of the order

[Louveduval]

sadly I've : 

Client	N°order	product	seller	date	Amount	Livre ?	total
A	01	tele	xxx	today	1500	O	6381,66
A	01	telecommande	xx	today	50	O
A	011	aquaruim	xxa	today	3000	O	6381,66
A	012	canne a peche	xx	today	120	O	6381,66
B	615	tele	xxx	today	1500	N	6381,66
B	615	telecommande	xx	today	50	N
B	666	CD irunmaiden	xxa	today	6,66	O	6381,66
C	007	film	xcc	today	30	O
C	007	pistoler	xcc	today	50	O
C	007	alcool	xx	today	75	N	6381,66

best regard

[Louveduval]

Perfect thank you very much ❤️