Lost customer with month trend

[#1]

Dear all Expert,

I have to add Lost customer, recovered customer and new customer with Month trend recently.

I found someone do Lost Customer with this method: http://community.qlik.com/thread/39754

however, if i use this method, i can't show the number of lost customer with month trend.

it can only show the total number of current month...

our definition of Lost Customer is: 1.customer have no sales in previous 6 months (e.g. now is 20 - Jan - 2015, customer has no sales between 19-Jul-2014 to 19-Jan-2015, then customer lost on the date of 20-Jan-2015) 2. have sales before (e.g. on 18-Jul-2014 or before have sales)

do you have any better idea to deal with the lost customer？？？？

thanks，

Manie

[#2]

why no experts answer this question....help help help~~