number of unique rows in a table

[#1]

hi,

I want to count the number of unique rows based on different attribute in the table,

Week Ending Date	Target	Build ID	Modem	L1 Test Status	L1 Test hrs	L1 Blocking Issues
					96
2009-10-18	8650 WM 6.5	AB1	UMTS	L1 Pass	24
2009-11-15	8650 WM 6.5	AB2	UMTS	L1 Pass	24
2009-09-06	8650 WM 6.5	AB3	CDMA	L1 Pass	24
2009-09-06	8650 WM 6.5	AB4	UMTS	L1 Pass	24

so in this case based on the Week Ending Date],Target,Modem it should give me unique number of rows.

so for the above case for date 2009-06-09 the count should be 2 where as for the other 2 rows it should be 1-1.

I tried the aggr function but it seems to be giving me count as 1 for all the rows.

can someone please help.

Thanks,

[#2]

Hi,

i think your Week Ending Date Format might be with timestamp thats why its not giving you count

Change Format OF Week Ending Date in to 'YYYY-MM-DD'.......