get 2 lowest Customer name

[muthukumar77]

Hi,

I need to get 2 lowest sales Customer name in text box.

I tried to do a expression but its not working.

=only(if(Aggr(rank(Sum(-NetSales)),Customer_CompanyName)=1, Customer_CompanyName))

Can anyone pls tell what is problem?

[sunny_talwar]

May be try with FirstSortedValue()

Customer with lowest Sales

FirstSortedValue(Customer_CompanyName, Aggr(Sum(NetSales), Customer_CompanyName))

Customer with 2nd lowest Sales

FirstSortedValue(Customer_CompanyName, Aggr(Sum(NetSales), Customer_CompanyName), 2)

[devarasu07 · Accepted solution]

Hi,

Try like below,

=Concat(DISTINCT Aggr(If(Rank(-Sum(Measure)) <=2, Product), Product), ', ')

[sunny_talwar]

Can also be done using set analysis

=Concat(DISTINCT {<Product = {"=Rank(-Sum(Measure)) < 3"}>}Product, ', ')