Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please,
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
Hi,
The first expression given by Mr. Ramasamy ie." = FirstSortedValue(Name, Aggr(-Sum(Sales),Name))"
seems working fine for what you explained . . .
Hi,
Try this expression.
=only({<Sale = {'$(=Max(Sale))'}>} Name) &' - '& max(Sale)
Regards,
Kaushik Solanki
Nothing,
Thanks
Hi
Please try like this
= FirstSortedValue(Name,-Sum(Sales))
Hope it helps
Hi
Please try like this
= FirstSortedValue(Name, Aggr(-Sum(Sales),Name))
Hope it helps
Hi,
Tell us what output you expect.
Regards,
Kaushik Solanki
Hi,
The first expression given by Mr. Ramasamy ie." = FirstSortedValue(Name, Aggr(-Sum(Sales),Name))"
seems working fine for what you explained . . .
Perfect, thanks a lot!