Number of Group occurrences

[rajasan77]

Hi Need to find out the number of group occurrences.
I have two groups. I need to find out the number of occurrences of the second group for each first group.

Example:
GH1 : Dept1
GH2 : Emp1
GH2 : Emp2
GH2 : Emp3

Now, I should get 3 becuse i have 3 employees under dept1.
The dept1 would have any number of employees.

Please help.

 

[lbass]

distinctcount({table.employee},{table.department})

Or right click on the employee field (where it is located in the detail sectioni) and insert a distinctcount at the group level.

-LB