How to classify customers using calculated dimension?

Sun, 15 Sep 2013 10:41:08 GMT

Hi guys,

I have a sales table as below:

When I select 2012-01-01<=dateid<=2013-12-31, I want get the following table:

Defination:

New:Customers who have first purchase in 2012-01-01<=dateid<=2013-12-31,

Existing:Customer who both purchase in 2012-01-01<=dateid<=2013-12-31 and 2011-01-01<=dateid<=2012-12-31,

Reactivated:Customer who both purchase in 2012-01-01<=dateid<=2013-12-31 and before 2011-01-01.

That means for the 2012-01-01<=dateid<=2013-12-31,

A belongs to 'Existing',

B and C belong to 'New',

D belongs to 'Reactivated'.

Anyone has ideas?

Thanks a lot.

Re: How to classify customers using calculated dimension?

Sun, 15 Sep 2013 10:48:27 GMT

Hi, sorry for forget the attached document.

Gysbert_Wassenaar — Sun, 15 Sep 2013 17:13:52 GMT

See attached qvw