Error in set analysis

[#1]

Hi Guys,

Please check this calculation and let me know where the problem is. I want to get the name of the first customer is sales and show its sales.

Thanks.

=(sum({$<CUSTOMER={=aggr(if(rank(sum(SALES))=1 ,CUSTOMER),'' )}>}SALES))

[MayilVahanan · Accepted solution]

Hi

Try like this

=sum({<Customer = {"= rank(Sum(Sales))=1"}>}Sales)

Hope it helps

[#3]

Thanks , it worked...........