Count Total group by

[zet]

Hello,

I have this table 

Type	Source	NbPositions
D	BREHAT212	2
D	SiriusNG	8
D	-	1
A	BREHAT212	4
A	-	5
P	BREHAT212	5
P	SiriusNG	6
P	-	1

I'm using this expression to calculate NbPositions: count(Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

and I want to add new column using new expression to count total by type like this :

Type	Source	NbPositions	Total By Type
D	BREHAT212	2	11
D	SiriusNG	8	11
D	-	1	11
A	BREHAT212	4	9
A	-	5	9
P	BREHAT212	5	12
P	SiriusNG	6	12
P	-	1	12

Thanks in advance.

[Kushal_Chawda · Accepted solution]

@zet  try below

count(total <Type> Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

[zet]

Thanks a lot !