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
