Could you please make a screenshot of your options ?

Thanks

I don't have such options.

I'm using SQL SERVER 2005 and i've got:

Here is the solution of my problem

Count(distinct CASE Date WHEN '01/01/2010' THEN Compte ELSE null END) AS [Comptes Unique Jan],

Count(distinct CASE Date WHEN '01/02/2010' THEN Compte ELSE null END)...