Retrive field value with aggr

[ilanbaruch]

Hi All,

i want to retrieve best Sales-Rep of the month into a text object,

i calculated value with:

aggr(sum(amount),Rep_Name) )

but i neet the name....

any ideas?

[sunny_talwar]

Try this:

=FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name))

[ilanbaruch]

thank you!

I'll try my luck with another one:)

if I want to retrieve the best rep from specific dimension(department)?

[sunny_talwar]

Use the same expression in a straight table with department as your dimension.

[ilanbaruch]

is it possible in a text object?

[sunny_talwar]

You can use Concat function may be:

=Concat(Aggr(FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name)), Department), ', ')

or

=Concat(Aggr(FirstSortedValue(Rep_Name, -Aggr(Sum(Amount), Rep_Name)), Department), Chr(10))