Comulate Customers

[#1]

Hi All!

I have a problem.

I have a table with dates and customer ids.

I would like to create a chart which shows how many customers bought a product.

Data:

Date	Customer ID
2012.01.01.	A
2012.01.01.	B
2012.01.01.	C
2012.01.02.	A
2012.01.02.	D
2012.01.03.	A
2012.01.03.	B
2012.01.03.	C
2012.01.04.	E

The result will be something like this:

2012.01.01. 3 (different customers bought product)

2012.01.02. 4 (different customers bought product)

2012.01.03. 5 (different customers bought product)

etc...

Please help me!

Thanks

W

[#2]

Thank you Jagan Mohan!

Thats it!

Its great!

Regards,

W