how to get zero value customers

[#1]

i have a list of customers and sales. requirement is to display customers who has no sales in last 6 months. can some one help me with some idea to achieve this.

[MayilVahanan]

HI

Try like this

vDate1 = MonthStart(Max(DateField),-5)

vDate2 = Max(DateField)

Make sure that, date field is same.

Count({<DateField= {'>=$(=vDate1)<=$(=vDate2)'}, Sales -= {'*'}>} Customers)

or

Count({<DateField= {'>=$(=vDate1)<=$(=vDate2)'}, Sales = {0}>} Customers)

Hope it helps

[#3]

Thank you mayil, i didn't work this way. i got it to work using calculated dimensin with

=if(aggr(sum({<$(tDim)=$(vMonthWeek)>}Sales),Customer)=0,Customer,null())