problem in total

Hi,

i created one query in which i m supposed to show no of employee retiring in a particular year

now the requirement is it must show all the employees retiring in dat year not individaual hw it can b done .

like yr 2007 yr 2008

2 4

presently showing

1

1

1

1

1

1

yr 2007 yr 2008 are my formulas

thnx