New Customer and Dead Customer between Max Year and previous Years

[ghassanaldalati]

Hi All... Please help me.

I am create ListBox for New Customer have sales in max selected Years and have no Sales in previous Years from Years selected Rang

if I select Year 2014 - 2015 - 2016 - 2017 and I want to show only the new 2017 customer with sales amount

" =if(sum({$<Year={"$(=max(Year))"}>}Sales)=0 and sum(Sales)>0  then show me the new customers with sales amount "

also I need to create another customer list for dead costumes have sales in previous years and have no sales in max year

please help me how to use IF statement in my expression .

Thank;s and regards

[sunny_talwar]

What is the output you expect to see for the sample data that you have shared with us?

[ghassanaldalati]

but how can i get in listbox title , the summary total in min year for Dead Customers in max year

in another word .. ( the diffrent between Max Year and Min Year for The dead customer how have no sales or negative sales on max year and have positive sales in min year

sorry again for my complecated qusition...

thank you fro your cooperation and regards

[sunny_talwar]

What is the number you are expecting to see for the sample you have provided? Give me a number that I can try to get