Hi All,
Can Anyone help me to get Top 10 customer from last month those are out from the list of top 10 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"
EXPRESSION FOR YEAR SCENARIO
:
=
IF(
aggr
(
rank
(total
aggr
( Sum( {<Year={"$(=year(Max(TRANSACTION_DATE))-1)"}>} SalesDetail_Amt),CUSTOMER_ID
)
,0,1)
,
CUSTOMER_ID
)
<='$(VTop)',
IF
(
aggr
(
rank
(total
aggr
(Sum( {<Year={"$(=year(Max(TRANSACTION_DATE)))"}>} SalesDetail_Amt),CUSTOMER_ID
)
,0,1)
,
CUSTOMER_ID
)
>'$(VTop)'
OR
ISnull
(aggr
(
rank
(total
aggr
(Sum( {<Year={"$(=year(Max(TRANSACTION_DATE)))"}>} SalesDetail_Amt),CUSTOMER_ID
)
,0,1)
,
CUSTOMER_ID
))
=-1,
CUSTOMER_ID
))
nOW I WANT TO APPLY YEAR CURRENT AND PREVIOUS MONTH SCENARIO.
This expression is working fine.
Regards,
Dushyant