How To calculate Total Number of Employee in shift wise

Dear Gurus,

my requirement is calculate the total no.of employees present & absent in shift wise.

My output like this.

Department Shift Present Absent

Information Technology GSFT 56 24

Engine Shop ASFT 124 26

BSFT 155 45

CSFT 80 20

Thanks,

Rajkumar.A