Top 100 customer of previous month not available in current month

[#1]

Hi All, Can Anyone help me to get Top 100 customer from last month those are out from the list of top 100 customer of Current month. Let say i am having Top 10 customer for Jan-2011, And Top 10 customer for Feb-2011 Now i want those customer only those are present in jan top10 list but not in Feb top 10 list. I am having expression for year like "TOP 10 CUSTOMER IN PREVIOUS YEAR BUT NOT PRESENT IN CURRENT YEAR"

Anyone having same scenario ,sample application or expression, any suggestion.

PLEASE MAIL ME @

dushyant.ntpc@gmail.com

Regards,

Dushyant

[#2]

Top 100 Customers from last month which out of the 100 Customers for the current month:

=if(aggr(rank(sum({1<varDate = {"=Monthname(varDate)=Monthname(Today(),-1)"}>}Amount)),Customer)<=100
and aggr(rank(sum({1<varDate = {"=Monthname(varDate)=Monthname(Today())"}>}Amount)),Customer)>100,Customer)

[#3]

Hi Nicolas,

Thanks for your reply but can you apply the same expression in my application's logic in which my SCENARIO(Top 100 Customer in previous Year but out of present Year) is working fine but that didnt work in the scenario of Current and month .

Where Cuurent month is my selected month and previous month is selected-1

Can you help me to get this result .

Mail me at:

dushyant.ntpc@gmail.com

Waiting for your reply.

Regards,

Dushyant