Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
PLS EXPLAIN ABOUT THIS EXPRESSION? ................
IF(AGGR(RANK(SUM(SALES)),CUSTOMER,SALESPERSON=1,SALESPERSON) AND
IF(AGGR(SUM(SALES)),CUSTOMER,SALESPERSON) AND
IF(AGGR(SUM(SALES)),CUSTOMER) <=2,CUSTOMER)
Please explain me about these three expresions PLs...............................................................
I AM GREATFUL TO U
if the sales done by the salesperson is ranked the first when grouped by customer and salesperson
and...
the third says
if the sales for a customer ranks in the top 2 display the customer
Your second if condition looks incomplete.
Hi
The Expression is wrong
Are you getting any result for this expression??