Find unique values using pivot table in sql

[ajaypal]

Please go through the above image. I want to get unique values by creating pivot table. But iam not getting Unique Designations. Pls help me.

Thank you in advance.

regards
ajay

[Muj9]

select
Designation
,sum(case when gender = 'M' then 1 else 0 end) as M
,sum(case when gender = 'F' then 1 else 0 end) as f
from emp
group by
Designation

[ajaypal]

Thank you very much