Hi Experts,
I am having a itab like
deptno dname empno
10 abap 100
10 abap 101
10 abap 102
10 abap 103
20 sd 104
20 sd 105
20 sd 106
30 mm 107
30 mm 108
40 fi 109
50 crm 110
I want output based deptwise total employes like
deptno dname tot-emp
10 abap 4
20 sd 3
30 mm 2
40 fi 1
50 crm 1
Can please tell me logic for count empno based on deptno.
thanks in advance.
manisha.