Top 5 Customer

tripatirao · ‎2015-10-07

Hi all

I want to show top 5 customer in my textbox.

this is my expression.

=concat(DISTINCT if(aggr(rank(sum({<DELTYPE={SALES}>}AMT_TRANS*$(=Curr_Factor))),CUST_NAME)<=5,CUST_NAME)& CHR(13))

the above expression gives me top 5 customer in a text box but not in proper ascending order.

for ex-

2nd top selling customer coming first

5th top selling customer coming second

but

I want in ascending order.

Thanks in advance.

sujeetsingh · ‎2015-10-07

Follow this

Report Inappropriate Content · ‎2015-10-07

Hi Tripati,

Go through the below link it might help u

Report Inappropriate Content · ‎2015-10-07

Hi Tripati,

Digvijay_Singh · ‎2015-10-07

There is a sort weight option in Concat, try if you can identify one of you weight field to be used to sort your values.

Report Inappropriate Content · ‎2015-10-07

Hi,

Try with this link

Report Inappropriate Content · ‎2015-10-07

tripatirao · ‎2015-10-07

Hi

i am not able to get sort weight in concat function...

any solution

thanks

Related Topics