How to create report to count number of customer buy in last 3 year ?

[paulyeo11]

Hi All

I need to create a report to count how many customer continous buy in last 3 year by GROUP_CLASS ?

I have a filed = Year_n , when = 1 , meaning year= 2014

Now i like to know if customer buy in 2014 2013 2012 , count as 1. and like to know which group have more continous buy customer.

Hope some one can give me the expression.

Paul

[paulyeo11]

Hi All

Enclosed my QV doc

Paul