7 Replies Latest reply: Apr 4, 2013 7:20 AM by rodrigoagostin

# [Solved]How can i get a single row

I need show a single row of Sales, i wanna show  the best seller.

Example:

Name - Sale

Rodrigo - 10.000,00

Bruno - 3.000,00

Lucas - 5.000,00

I wanna show the Rodrigo's sales in a Text Object.

Thanks

• ###### Re: How can i get a single row

Hi,

Try this expression.

=only({<Sale = {'\$(=Max(Sale))'}>} Name) &' - '& max(Sale)

Regards,

Kaushik Solanki

• ###### Re: How can i get a single row

Nothing,

Thanks

• ###### Re: How can i get a single row

Hi

= FirstSortedValue(Name,  Aggr(-Sum(Sales),Name))

Hope it helps

• ###### Re: How can i get a single row

Hi,

Tell us what output you expect.

Regards,

Kaushik Solanki

• ###### Re: How can i get a single row

Hi

= FirstSortedValue(Name,-Sum(Sales))

Hope it helps

• ###### Re: How can i get a single row

Hi,

The first expression given by Mr. Ramasamy ie." = FirstSortedValue(Name,  Aggr(-Sum(Sales),Name))"

seems working fine for what you explained . . .

• ###### Re: How can i get a single row

Perfect, thanks a lot!