Student with same company and department

[D19PAL]

Hi,

I need to count how many students have the same company and department 

This is the full outcome.  If I sum flag in a kpi box I'll get 7.

In a straight table, I'll get 7 rows like below.

Form,student,company,dept,flag

4,1122,asda,A,1

5,167,asda,A,1

9,113,asda,A,1

8,167,Foxy,A,1

12,113,Foxy,A,1

6,167,comment,A,1

13,114,comment,A,1

Thanks

Form,student, teacher,company, dept

1,1122,167,tesco,a

2,1122,167,sainsbury,a

3,1122,167,Morrison,a

4,1122,167,asda,a

5,167,113,asda,a

6,167,113,comment,a

7,167,113,taser,a

8,167,113,foxy,a

9,113,167,asda,a

10,113,167,roxy,a

11,113,167,troxy,a

12,113,167,foxy,a

13,114,167,comment,b

14,114,167,black,b

15,114,167,blue,b

16,114,167,red,b

[Taoufiq_Zarra]

@D19PAL  can you share the expected output

[D19PAL]

This is the full outcome.  If I sum flag in a kpi box I'll get 7.

In a straight table, I'll get 7 rows like below.

Form,student,company,dept,flag

4,1122,asda,A,1

5,167,asda,A,1

9,113,asda,A,1

8,167,Foxy,A,1

12,113,Foxy,A,1

6,167,113,comment,A,1

13,114,167,comment,A,1