adding calculated column with group by

[df123445]

Hi all, 

I would like to add to each line a calculated column based on a group by:

customer	sales rep	product	tot
C1	S1	P1	3
C2	S1	P1	3
C3	S1	P1	3
C7	S1	P2	1
C4	S2	P1	1

basically I would like to add a column that shows how many records I have for each sales rep/product couple

regardless of which customer bought it.

Many thanks in advance. 

[Ahmedx · Accepted solution]

pls try this