Sorting issue in Concat function

[kkkumar82]

All,

I have created a expression in text box as =Concat(SalesManID,',') and I am selecting a Product in the list box.

My requirement is

Would like to see all the SalesmanID associated with the selected product.

I was able to see them using concat but when I am trying to sort them descending by their sales I failed.

I think I missed some thing in the aggr I used for sort weight.

Thanks

Kiran kumar

[sunny_talwar]

May be this:

=Concat(If(Aggr(Rank(Sum(Sales)),[Product ID],[Salesman ID])<=5,[Salesman ID]),',', Aggr(Rank(Sum(Sales)), [Product ID], [Salesman ID]))

[maxgro · Accepted solution]

try

=Concat(distinct [Salesman ID],',', -aggr(NODISTINCT sum(Sales),[Salesman ID],[Product ID]))

[kkkumar82]

Hi Maxgro,

I tried with altering the dimension list in aggr to ProductId and SalesmanId it was working fine, just curious to what "NoDistinct" is doing for sorting.

Can you delve here, about NoDistinct

Thanks

Kiran Kumar