I made it as you said, so far so good. Thanks again.
As I said, I forgot to mention that I need to deal with orderdates. So I need to see this per orderdate. Could you please explain to me how I need to do that?
So, the inline data will look like this:
CUSTOMER, ORDERID, Date
Customer X, 15154, 15-02-2012
Customer X, 21644, 15-02-2012
Customer X, 22564, 18-03-2012
Customer X, 22578, 18-03-2012
Customer X, 54650, 18-03-2012
Customer A, 12345, 12-03-2012
Customer A, 15648, 15-03-2012
Customer B, 99999, 15-08-2012
Customer B, 88888, 15-08-2012
The result should be:
Customer X on two rows for 15-02-2012
Customer X on two rows for 18-03-2012
Customer A on one row for 12-03-2012
Customer A on one row for 15-03-2012
Cusomter B on two rows for 15-08-2012
Thanks in advance!